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.
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👍
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.
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.
@@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 apne comparison operator ka use to sahi se samjhaya pr in aur exist ka use sahi se nahi samjhaya,samajh hi nahi rha ki aap ky kr rhe ho aur kyu kar rhe ho
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 ✅️✅️
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".
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 ✅️
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 ✅️
Ek number Rishab bhai what a nice way of explaining.
Glad you liked ✅️
Glad you liked ✅️
I got new concept "सब कुछ ", Thanks a lot.
Glad it was helpful ✅️
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👍
Excellent job sir salute 👏
Thank you very much sir, you are the best teacher 🎉
Glad you liked the content ✅️
Thanks a lot sir...
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..
Aapka Tahe Dil se shukriya bhai.
Happy to help ✅️
Thanks You explained in a easy and excellent way !!
Glad it was helpful! ✅️
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
U are teaching like we are knowing every thing
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 ✅️
Thank for this tutorial ! ❤
Glad you liked ✅️
very nice sir
Thanks for this course
Glad you liked ✅️
Fabulous explaination❤
Glad you liked ✅️
Well explained
bohot bdhiya
very nice explanation...
Glad you liked it ✅️
Finished watching
Awesome ✅️
Plz add some SQL practice in your every vedios .it will be more helpful for us..😢
Okayy noted ✅️
Finished practicing
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
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
Rishab bhai ek video exadata par advantage
Aur normal database difference par video bana di bhai
Select * from customer where amount > avg(amount) is this correct
when you have used in operator what is the role of mode in the line ?
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
is this enought to data analyst bro ?
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?
Sir aapka paid course bhi available hai if yes i glad to join it.
No paid course, only TH-cam 👍
Sql ka ak pura video bhnay data analysis kh liy
already uploaded sql project
is there any website where we can practice some queries? Any suggestions?
Yes there are many like w3schools
hacker rank, leetcode , w3 school
Bhai bina subquery from me bhi lagti he, wo nhi bataya, uska alag video he ?
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?
For better packages python is mandatory. Else, it is enough.
sir apne comparison operator ka use to sahi se samjhaya pr in aur exist ka use sahi se nahi samjhaya,samajh hi nahi rha ki aap ky kr rhe ho aur kyu kar rhe ho
make a videon temporal function in details like from year how to extract month
Okayy noted ✅️
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
Sir plz ans my question 😢 sir 2 table ko join kese krskte hain koi column name same na ho sir plz iska ans deden
❤
upload English videos sir
can we prepare a subquery using HAVING clause?
Yess.. just like, we did with WHERE clause 😀
Sir, mujhe SQL basic pata hai..kya mujhe course buy karna chahiye ?
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
Someone pls mention employee table details agni vayu wala pls i need this table
All data file links are in video description, and if data is small, you can create your own table 👍
@RishabhMishraOfficial bhaiya aapne jitna use Kiya hai utna pls mention kariye uske bina muje samjh nhi aarha hai
@RishabhMishraOfficial is wali table ki details aapne mention nhi ki hui hai
subquery pr ek 2 hours ki video leh aao bhiya ?
Okayy noted ✅️
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)
Were got a SQL pdf sir
Link in video description
bhaiya date year month dalte ni aa rha
👍
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
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.
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 ✅️
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