SQL "difference between" interview questions (part 2)

This is the second part of SQL interview questions.
The questions covered in this video are:
1) Difference between group by vs order by?
2) Difference between join vs sub query?
3) Difference between join vs union?
The part one video can be found here:
• SQL "difference betwee...
Do check the video. The questions covered in first video are:
1) Difference between where and having?
2) Difference between union and union all?
3) Difference between in and exists?
Thank you for watching!
✨Work related mails can be sent on:
[e-mail]
✨If you appreciate my work and would like to donate to support our channel, you can do so here:
paypal.me/sadia1702

[@crackconcepts]

✨Link to my SQL e-book: imojo.in/rkajq9
✨Link to 'Switch your career easily' e-book: imojo.in/1FL7KaG
(Perfect for anyone willing to switch to a completely new field or to a different company in the Tech World)

[@b_aleman]

I've taken a few classes on SQL (years ago) and this made more sense to me. I think I'm beginning to understand. I will need to watch this a few time and practice while pausing the video to make sure I'm getting it. But great job. Thank you.

[@crackconcepts]

Thanks a lot!

[@husein_alfil]

Thank you for creating those great Videos .. I can say that your videos are the #1 on TH-cam and they are fully explained .. Please keep the great content ! :D

[@garimasharma2558]

just have an interview tomorrow and your videos really helped a lot for revision. Thanx a lot

[@NickySauce]

Did you crack it?

[@manojandraju2161]

@@NickySauce ahahah

[@vaggisivababu9581]

Hi

[@DigitalLearningWithMB]

Share interview questions

[@pablochocobar]

@@NickySauce She never came back, that means she did I guess.

[@honestcomments8053]

You're an excellent teacher! Thank you.

[@sreedharraor]

I learnt these SQL queries as part of my diploma course from CMC in the year 1999 but I understand better now. :) Good job. 👍

[@donahisoto]

You do this in a really basic way that makes all really clear, thank you

[@SumeshMuvvala1]

You have reminded my friends. My friends used to explain to me before the exams like this. Thank you for making the effort to present it easily.

[@MadiraSarkar]

I have interview tomorrow, it’s Sunday morning in my city, and I am watching your videos. You are doing amazing girl .

[@SergioGarcia-gd6ti]

Your videos are very practical and concise, thank you very much...

[@manish36556]

the best videos i had ever seen for interview preparation ..seen all your videos and it helped me a lot. thanks for this ..

[@virendrabhati6685]

Again you explain in simple language with example. Keep posting such a small short video with in-depth details 👍

[@lingeswarkumarasamy9175]

You way of teaching is superb and also your hand writing is awesome.

[@topone6860]

Your videos tells,,,,,,graphics, equipments or anything is not important........ only matter is important like in your videos..... such greatest job u r doing.......very useful thank you so much...... 🙏🙏🙏

[@zaffarkhan620]

You are doing really great job. This video Play list is really helpful for the candidates.
God bless you.

[@crackconcepts]

Thank you for your kind words 😊

[@sampathkumar2506]

Your explanation is simple and very useful for interview purpose ...Thanks a lot 😊

[@lighithiyer664]

These are some concepts which are often misunderstood but you made it easy.

[@kathipogudavidpaul3634]

impressed by the way you portrayed the concept and expecting more from you madam

[@statusking-nc5ug]

You are the inspiration for future job seekers

[@bukolaadebayo1891]

Thank you so much. You really broke the concept into the very basics.

[@andyn6053]

Thanks for your wonderful video! Really helped made it more clear for me!

[@prasanthmurali3144]

Keep up the good work.. just subscribed ur channel. Clear explanation 👌..Thanks for ur effort

[@UsamaAli-by8jx]

nicely explained and much helping for understanding the difference, Thanks for making this video.

[@vasantgaikwad]

Very nice, great concepts examples nice... Usefull thanks..

[@jeetugupta9880]

I really liked the way of representing the concepts in your video. i have also got some feeds from your video. Thankyou very much.

[@FonchoRG]

Thank you for your videos. Your explaination are very clear. I apreciate it very much.

[@mohitkishan8956]

i appreciate your efforts.. Kudos for helping people who are searching jobs

[@Mahesh717]

your explanation is just next level... 💯🔥

[@ddamshreds]

Crisp and quick explaination!

[@saran79]

Revised my knowledge in quick time. Thanks

[@sona4612]

Wow🔥🔥🔥 such a great video.. thanks a lot..

[@topone6860]

And also ur way of explaining thing with ur sweat voice great.....

[@abhijeetghosh27]

Thanks Sadia for creating and sharing this video. Informative 👍👍

[@AakashPanditOfficial]

Speechless... So awesome tutorial

[@vaishnawsingh3726]

The amount of hard work you are putting is commendable.....one suggestion...use ppt and screen recording ....for your ease and better understanding to the learner...keep it up girl

[@rawtigro]

Greatly explained...👍🏻

[@akp_321]

Just watching your video....its really helpful 😄😄😄😄

[@balusister1991]

Great, it's always great grasp from the paper teaching becoz it's natural. Artificial will not give strength to learn more... ❤❤❤

[@pritamnerkar996]

Your videos are really helpful. Thank you :)

[@adampopovsky9305]

Iam in first semester in college (software engeneering) so I really appreciate this rewind of all functions, becouse tommorow I have exam on this.

[@vanamharish3]

Thanks a lot for revising the concepts in short time. And your voice resembles the singer swarnalatha.

[@virendrabhati6685]

"Thank you for making video"......
I want to say "Thank you for making such video"🙏

[@renugopalsiva1196]

I love your teaching ❤️

[@sandeepkumar-fv3gj]

It is really helpful 🙂 to interview. Thank a lot.

[@chakravartit.5442]

Nice Explanation..and esay to understand 🙏

[@warunsharma3995]

Great explanation maam

[@krishna9971]

Very helpful video, it cleared my doubts. Thank you🥰

[@RohitSharma-ny1oq]

Love the way of ur explanation..

[@krishnaswaroop1498]

Thanks for your great explanation

[@funnytalkies-vj2gs]

Very deep understanding

[@C.Sakthivignesh]

Thanks mam for made this video.

[@indiannewyorkbabies6872]

Please explain more left join, right join along with group by. Great job New Sub

[@mymukeshjena]

Your videos are super way of explain 👍

[@hellopeter6061]

Thankyou for best explanation

[@ankitapandey7207]

nice videos with simple examples

[@ignatious6801]

thanks a lot.
that was very much helpful.

[@nayazpasha5963]

Good explanation mam 👍

[@kamalakannan9283]

Thank you so much 🥰

[@lokeshmalkani1144]

Thankyou somch it was very clear and informative...

[@Vikaskumar-ur5di]

thanks for sharing good information

[@frankdrayton9715]

correction> is it select DISTINCT cust_id from orders?

[@TheRockAbhi]

Very well explained

[@syedifranejaz8680]

Very Informative 🔥

[@hasanzaidi6645]

Thanks Now my doubts are cleared.

[@tanushreenagar3116]

Nice mam 👍 thanks 😊

[@Amrithayellow]

kindly help with more of such great videos.

[@lolipops8503]

brilliant. thank you

[@janagamasanthosh1087]

nice explaination thanx....

[@UsamaAli-by8jx]

Good stuff

[@nagarajanerode]

Good crash course video.

[@pannagabm2100]

Thank you❤

[@MotiLal-nb4tt]

Thanks a lot for getting me a job

[@mhg9154]

Great job. Keep it up. Very good explanation.

[@abhisheksoni5273]

Thank you

[@basityar1494]

You just earn one subscriber from here.... 👍

[@Abdallah-ph3ef]

Thank you a lot

[@francisfrancis1759]

hi nice explanation good job ,,,,,,,,,,,one suggestion in joins it combines columns ,,,,,,,,,,i think by mistake u wrote rows ,,,,,,,,,,,thanks

[@ritheshbhat1153]

when we go for subqueries. if the result of inner query gives result which are present in outer query. i guess that will work? ( table b has reference to table a ) correct me if i'm wrong

[@106107027]

Good 👍

[@ankursingh730]

Any suggestion for SQL course to be taken for beginners/intermediate/advanced level?

[@dineshkumarkmk]

I think it should be order by follows where clause in select stmt

[@DanishKhan-mc9xj]

Thank you so much

[@jaswindersingh-zh8qr]

thanks

[@surendrapradhan4303]

I have 3 table ...I have to count nodename which order is closed in 5 year later and current year...can u guide me how can I write the query

[@katreji]

Having clause is used after group by clause.
Where clause is used before group by clause.

[@mehulsoni2300]

very nice content

[@Gautamkumar-pk2uk]

Kindly help in performance tuning part of any queries.

[@mssqltips_and_tricks.]

Can you show different and more examples it's help for us

[@sarathbabu3952]

Voice super madam

[@OpinionOfX]

👍👍

[@adityaghosh8601]

Great

[@rohitjain3196]

Hi ma’am,are you giving one on one online classes
Thanks

[@rathulkrishnan8236]

good

[@vishalsawant9461]

Why join is faster than subquery?

[@paramchannel600]

Cute voice mam... Teaching is also wonderful..Keep going 👍

[@hajaaa100]

Can you explain ACID properties

[@akashparihar515]

++

[@nomansattar1486]

can you share your notes ?

[@Telugufun427]

IT IS 5,4,3,2,1 JI

[@ARPITTHEIRONMAN]

hey miss firstly you are teaching excellent and secondly, your voice is so sweet. Very soon you will have a great youtube channel and i will try my best to do so.
love u !

[@SpaceTimeBeing_]

Creep

[@akashchandak8917]

You are teaching superb but voice is to slow . And please explain why join do faster and sub query slower.

[@karthikkarki1849]

Hi, one small suggestion. Instead of saying conditions like "you have to see that video", please say like "the link for that video is provided in description". So that it will be satisfying for viewers and will be an effective video...