This video is very helpful for me mene es se pehly bohat sari palylist ki or join wala topic samjhny ki koshish ki but phir b me paper me question krny ky qabil ni thi jesy h mene ap ki videos dekhi hy me join ky related kisi b qisam ka question achy se kr sakti ho Thanks Again sir g👍
Rishabh bhai, tum bohot mast teacher ho...concepts ek hi baar me samaj aajate hai and that too in a very structured manner. Keep it up! Love you Sir. We are so happy for your teaching. dill se thankyou aapko.
Very nicely explained, Rishab. However, I have one request regarding this particular video. Could you kindly mention the question for the "Logical Operator & Exist Operator" before starting the chapter? Just like you did with the question for the "Compression Operator" at the beginning, it would help provide more clarity. The rest is okay. Thank you.
Wow this was an amazing video, I came here just to solve my doubt about subquery but now feels to watch all of your videos about sql. Really amazing video and I will also promote about you on my channel soon when i start my channel. This is how real professional helps to learners like us. I would like to connect with you over linkedin so if you don't mind please drop your connection link.
@@RishabhMishraOfficial Resume mein SQL karke likha hu aur itna sikhe ke aapse gaya aur interview questions top-50in SQL sikha hu Google se max sab topics hein he bas thoda udhar idhar miss tha bas ek fresher keliye itna kaafi heina Bhai
Sir there is record in column which is split through (,). I want to remove every character that starts with coma and there are multiple like that in table. Is there a query which removes characters starts from coma now matter what there length is? Plez help
The answer is yes... I am sharing the syntax of something similar that I did .. select C.custid,C.custname,O.order_qty from customer_test as C join orderid_test as O on C.custid=O.custid where C.custid in (select custid from orderid_test)
Bro please make one video on advanced sql & include all topics such as with Clause, cte rank, dense_rank, dynamic sql temporary function, pivoting, lead & leg, except vs not in, delta values, row_number, views, cast func., top func., Select into, sql index, sql transaction etc.
Hey a beginner here . Can't we just write this instead of using a subquery ? Just a beginner doubt please correct me . SELECT * FROM payment GROUP BY customer_id HAVING amount> avg(amount);
Rishabh bhai, tum bohot mast teacher ho...concepts ek hi baar me samaj aajate hai and that too in a very structured manner. Keep it up!
Glad you liked it ✅️
bhai ap aise padhate ho jese revision karhe ho, apko as a newbie smjhana chahiye joki first time padhrha ho !!!
Okayy bhai, next time aur simple and slowly samjhayunga ✅️✅️
This video is about when a working professional teaches you. They will know every corner on how to make you understand the concept.
Glad you liked it ✅️
This video is very helpful for me
mene es se pehly bohat sari palylist ki or join wala topic samjhny ki koshish ki but phir b me paper me question krny ky qabil ni thi jesy h mene ap ki videos dekhi hy me join ky related kisi b qisam ka question achy se kr sakti ho
Thanks Again sir g👍
Tip:
If your struggling to create table like sir just take screen shot paste it on chatgpt and write prompt "Create table using sql query".
Rishabh bhai, tum bohot mast teacher ho...concepts ek hi baar me samaj aajate hai and that too in a very structured manner. Keep it up! Love you Sir. We are so happy for your teaching. dill se thankyou aapko.
Glad you liked ✅️
I got new concept "सब कुछ ", Thanks a lot.
Glad it was helpful ✅️
Excellent job sir salute 👏
Very nicely explained, Rishab. However, I have one request regarding this particular video. Could you kindly mention the question for the "Logical Operator & Exist Operator" before starting the chapter? Just like you did with the question for the "Compression Operator" at the beginning, it would help provide more clarity. The rest is okay. Thank you.
Glad you liked n Noted ✅️
U are teaching like we are knowing every thing
Aapka Tahe Dil se shukriya bhai.
Happy to help ✅️
Thanks You explained in a easy and excellent way !!
Glad it was helpful! ✅️
Thanks a lot sir...
Thank for this tutorial ! ❤
Glad you liked ✅️
Wow this was an amazing video, I came here just to solve my doubt about subquery but now feels to watch all of your videos about sql. Really amazing video and I will also promote about you on my channel soon when i start my channel. This is how real professional helps to learners like us.
I would like to connect with you over linkedin so if you don't mind please drop your connection link.
Glad it was helpful! ✅️
LinkedIn link in video description
Fabulous explaination❤
Glad you liked ✅️
Bhai SQL ka sara topic samajh aaya pr ye sub query utna clear nhi hua...😢
Okayy, iske uppar phir se ek video bana dunga
@@RishabhMishraOfficial ha ha plz🙏🏻samjha but still confused plz make a video before 27 August
You can go and check campusx subquery video
@@shwetamishra5813
Han bhai samajh mein nahin aa rha irritated ho raha hoon
@@RishabhMishraOfficialyes sir ek or video banao na sub query ka..
bohot bdhiya
Plz add some SQL practice in your every vedios .it will be more helpful for us..😢
Okayy noted ✅️
nice explanation...can you help me to understand the exact difference between IN and EXISTS operator in subquery...?
IN operator always picks the matching values list, whereas EXISTS returns the Boolean values TRUE or FALSE
In select the matching values
very nice explanation...
Glad you liked it ✅️
Thanks for this course
Glad you liked ✅️
Well explained
very nice sir
instead of writing a sub query, can't we just direct put where amount> avg(amount) in the example
Try if you get the same result then yess
Ek doubt hein kya sirf aap jitna sikhaye ho utna seekhna kaafi hein kya fresher keliye interview keliye????
It's enough to get started after this you need to practice interview questions
@@RishabhMishraOfficial Resume mein SQL karke likha hu aur itna sikhe ke aapse gaya aur interview questions top-50in SQL sikha hu Google se max sab topics hein he bas thoda udhar idhar miss tha bas ek fresher keliye itna kaafi heina Bhai
Select * from customer where amount > avg(amount) is this correct
Sir, I am trying to get a job in the DA field, but I don't have Python skills. So, is Python mandatory, or advanced Excel, SQL, and BI is enough?
Rishab bhai ek video exadata par advantage
Aur normal database difference par video bana di bhai
Finished watching
Awesome ✅️
Finished practicing
Sir aapka paid course bhi available hai if yes i glad to join it.
No paid course, only RUclips 👍
is there any website where we can practice some queries? Any suggestions?
Yes there are many like w3schools
hacker rank, leetcode , w3 school
sir last mai nhi smjh aya kuch kab exist use kab In use krna hai .....and joins hi easy lga mujh to inse
subquery apan use kab karte hai?
is this enought to data analyst bro ?
when you have used in operator what is the role of mode in the line ?
Bhai bina subquery from me bhi lagti he, wo nhi bataya, uska alag video he ?
Sql ka ak pura video bhnay data analysis kh liy
already uploaded sql project
Sir plz ans my question 😢 sir 2 table ko join kese krskte hain koi column name same na ho sir plz iska ans deden
can we prepare a subquery using HAVING clause?
Yess.. just like, we did with WHERE clause 😀
Sir there is record in column which is split through (,). I want to remove every character that starts with coma and there are multiple like that in table. Is there a query which removes characters starts from coma now matter what there length is? Plez help
Sir ye date ka leya syntax bta degeye mtlb syntax kya hona chahiye
Or sir existing table ke andr or data kese add kese krskte hain sir plz iska bhi jawab deden
Can we use join and subquery at a time? If yes, please help me with complete syntax with these 2 tables (customer and payment) to get output
The answer is yes... I am sharing the syntax of something similar that I did ..
select C.custid,C.custname,O.order_qty from customer_test as C join orderid_test as O
on C.custid=O.custid
where C.custid in
(select custid from orderid_test)
make a videon temporal function in details like from year how to extract month
Okayy noted ✅️
Sir, mujhe SQL basic pata hai..kya mujhe course buy karna chahiye ?
subquery pr ek 2 hours ki video leh aao bhiya ?
Okayy noted ✅️
Sir in bsc cs passout student what is career opportunities after bsc cs ...i depressed bcoz i think choose worse field track i should choose btech
do mca brother
you can persue that
upload English videos sir
Bro please make one video on advanced sql & include all topics such as with Clause, cte rank, dense_rank, dynamic sql temporary function, pivoting, lead & leg, except vs not in, delta values, row_number, views, cast func., top func., Select into, sql index, sql transaction etc.
Okayy noted ✅️
Were got a SQL pdf sir
Link in video description
bhaiya date year month dalte ni aa rha
Next video kab aayge
after 2 days :) only 2 more videos then course will be completed. After that we will practice for SQL interview questions, tricky questions,etc
I have completed all videos today. I will be soon practicing them. I'm working on SQL but don't know to create complex queries.
@@mohdabdulhameed2347 Advance or complex queries will come by practicing SQL questions. More you practice more you will learn.
bhai aap nahi hote to mera kya hota
Acha hi hota 🚀
❤
the way you say sab kuch it irritates
👍
🤲🤲🤲👍🥇😊💐
Hey a beginner here . Can't we just write this instead of using a subquery ? Just a beginner doubt please correct me .
SELECT * FROM payment GROUP BY customer_id HAVING amount> avg(amount);
You can try that n let me know if it works