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
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.
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)
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👍
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 ✅️
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 ✅️
I got new concept "सब कुछ ", Thanks a lot.
Glad it was helpful ✅️
Excellent job sir salute 👏
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
Thanks a lot sir...
Plz add some SQL practice in your every vedios .it will be more helpful for us..😢
Okayy noted ✅️
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
Aapka Tahe Dil se shukriya bhai.
Happy to help ✅️
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
U are teaching like we are knowing every thing
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..
Thanks You explained in a easy and excellent way !!
Glad it was helpful! ✅️
very nice sir
Select * from customer where amount > avg(amount) is this correct
Thank for this tutorial ! ❤
Glad you liked ✅️
Well explained
Thanks for this course
Glad you liked ✅️
Rishab bhai ek video exadata par advantage
Aur normal database difference par video bana di bhai
bohot bdhiya
Fabulous explaination❤
Glad you liked ✅️
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
Bhai bina subquery from me bhi lagti he, wo nhi bataya, uska alag video he ?
when you have used in operator what is the role of mode in the line ?
Finished watching
Awesome ✅️
is this enought to data analyst bro ?
very nice explanation...
Glad you liked it ✅️
Finished practicing
sir last mai nhi smjh aya kuch kab exist use kab In use krna hai .....and joins hi easy lga mujh to inse
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
subquery apan use kab karte hai?
Sir aapka paid course bhi available hai if yes i glad to join it.
No paid course, only TH-cam 👍
is there any website where we can practice some queries? Any suggestions?
Yes there are many like w3schools
hacker rank, leetcode , w3 school
Sir ye date ka leya syntax bta degeye mtlb syntax kya hona chahiye
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 ✅️
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)
Sql ka ak pura video bhnay data analysis kh liy
already uploaded sql project
Sir, mujhe SQL basic pata hai..kya mujhe course buy karna chahiye ?
Sir plz ans my question 😢 sir 2 table ko join kese krskte hain koi column name same na ho sir plz iska ans deden
make a videon temporal function in details like from year how to extract month
Okayy noted ✅️
can we prepare a subquery using HAVING clause?
Yess.. just like, we did with WHERE clause 😀
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
subquery pr ek 2 hours ki video leh aao bhiya ?
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.
❤
👍
the way you say sab kuch it irritates
bhai aap nahi hote to mera kya hota
Acha hi hota 🚀
🤲🤲🤲👍🥇😊💐