SQL "difference between" interview questions (part 1)

In this video, we'll understand some important sql interview questions. These questions are often asked in interview and should be known by anyone who wants to master SQL.
Following are the questions which will be covered in this video:
1. Difference between where and having?
2. Difference between union and union all?
3. Difference between in and exists?
This is part 1 of this video.
Part 2 will be released tomorrow.
In part 2, the following questions will be covered:
4. Difference between group by and order by?
5. Difference between join and sub query?
6. Difference between join and union?
✨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

[@madhurpalsokar7790]

Best thing about your videos is You take very less time to cover many things and yet explaining it so beautifully.. Thanks for spreading the knowledge.. 👍🏻

[@kunalgandhe4551]

I've been looking for something like this from a long time.I've not seen any video where SQL is explained in such a simple and easy way. Thanks a lot for this.

[@radhemohannaamhai]

The way she says sorry sorry ❤️.. great tutorial ..am following every video.. simple and to the point ..

[@charlesmathews6184]

I gained confidence from your teaching. Kudos

[@sartz444]

Hi, The best thing is that All of your videos are clearly explained in a short period of Time and it covers many things. I Really appreciate ur effort and please keep on continuing it🙏🙏 Thanks you so much

[@dipakk123]

I am thankful that such a clear and knowledgeful information shared for all
May God bless you for the helping and sharing
thank you

[@anvi015]

Amazing video series on SQL. Honestly this has been my ONLY goto channel whenever I feel I need to brush up my SQL coding skills.

[@gauravnegi4312]

THANK YOU SO MUCH!!!! Cleared all the doubts in a single go!

[@tekieogubagabir43]

clear, simple and easy way of explanation , Thank you !

[@suhailahamed7514]

Thank you, sister, the way you teach is wonderful, stay blessed and happy forever. as a beginner, I admire your effort.

[@rohanmali6583]

This and the second part is sooooo Awesome. You Rock. Blessings from United States. :)

[@chandrassqlbi4343]

Great job sis.. kudos!!
Small correction @ 3:33 ---- 'Where' can be used while aggregating rows (Where and Group by works)
'Where' will filter at Row level
'Having' will filter at 'Group by' level
No intention of pointing out mistakes here.. your channel is gaining popularity, and many are learning from this channel, great job!!. On the same lines - my two cents .. if that helps your viewers!!
Oh, I haven't seen before - couple of others also mentioned about this correction.. great!! Good job!!
(wouldn't have posted this if i have seen that earlier)
Good job everyone!! Happy learning!!

[@crackconcepts]

Thank you 😊

[@antonyjayaraj95]

I really like the way you explained and it is useful for me...

[@praveengupta2369]

Sir I need to add few more points and let me know if I am wrong. If where clause is being used after the 'group by' statement this wouldn't work out. If we want SQL to use group by with where, 'where clause' should be used before Group by statement which actually filters the data from reference table first then grouping the data. Since, we are not using any aggregate function to group our data hence this group by also acts like order by. Disagree if I am wrong

[@rameshmalhotra9525]

ruclips.net/video/p0gL1pAhGZE/видео.html

[@vaishalidharmik2038]

Thanks for this. I could have got wrong understanding now about using HAVING clause.

[@sohailkat8867]

I have started watching your videos recently, believe me you are amazing the way explained just nailed it.Impressive work keep it up last but not least thank you.

[@crackconcepts]

Thank you so much!!

[@vS-mn9id]

God bless... very straight to the point... Perfect... Kudos to your work

[@anunutan9220]

Ur way of explaining concepts is simple and cool to understand soon....
Tq for sharing videos..

[@vivamedia5958]

Great tutorials. Thank You very much. looking forward for more videos from you.

[@shreyjainhere]

Your voice is really sweet Mam.. A very good and simple way of explaining 👍

[@archanapbhat5232]

Thank you..Concepts clearly explained in short time..GOD bless you

[@vminkook_lover782]

Whatt a Amazing voice !!!😍😍🥰♥️
& Explanation is also good 💜

[@bootexcel5122]

Nice. You are explaining things clear. Like inner query and outer query.

[@tariqzaman2077]

A good and knowledgeable video, thank you sister for sharing with us.

[@Faisal1504]

Thanks for sharing very well explained

[@anujlovetube]

Best sql channel ...thanks mam for this series and all effort u have put in

[@virendrabhati6685]

It was a great video of explaining such a complicated concepts 👍.

[@shahzan525]

Most usefull .....
Great work 👍

[@kumarakrish3976]

Proper explanation with great presentation 😊

[@ajajjamadar]

Great job sister . Best tutorials I have ever seen . Keep it up

[@nagoredeen]

You can still use WHERE clause aggregated functions.
Select max(column) from table where
Meaning: select max out of a column value from a table with a filtered records based on a condition.

[@ruturajjadhav8905]

Yes.
And we can't use having without group by

[@nishiagarwal9869]

Yes

[@rameshmalhotra9525]

ruclips.net/video/QTaiF8N6i3Y/видео.html🙏🏻🙏🏻

[@chilly2171]

This RUclipsr has no idea what she is talking about man....

[@rameshmalhotra9525]

ruclips.net/video/p0gL1pAhGZE/видео.html

[@Sam_yemjala]

What a voice dude , damn pleasant

[@SameerShaikh-ty5zt]

Thank you.. Your way of explaining is sweet.

[@331sairam]

Straight concept clear voice ....cool

[@deepakpandey9406]

1. Aggregate
2. Duplicate
3. Scan and Boolean evaluation
4. Position
5. Performance
6. Columns and Rows

[@CodeWithFiroj]

Good one.

[@itdp.warangal]

I think this video was done at election time. This video helped me now. Nyc1

[@Kamil0289]

Simply explained, thank you :)

[@manognakarimi]

To the point ,
helped me.
Thank you 😀

[@prashantp9029]

Good job mam👍👍
Please upload more videos regarding plsql with examples as many as u can .
Your explanation is tremendous ...

[@anilb5557]

thank u mam such simple explaination about union i never understand my whole enginnering .....keep provide us such .. this type of information... thank u so mmuch ......🤗🤗🤗🤗🤗🤗🤗

[@mukulverma9966]

You are explaining so good and your voice also amazing
Great work mam

[@zaidzeee]

Amazing work keep it up

[@gauravghosh8002]

Thank you so much Ma'am for your detailed information. This helped me to brushed up

[@yasmeenhasan9925]

Thanks for the making videos! Its very very helpful

[@vijaypanchal7344]

Nice tutorial and clear voice to understand.

[@bhushandatey5792]

very well explained . I watched just one video & subscribed .

[@buildtolearn]

Love these videos. Great job!

[@nelikantinagaraj4866]

Very very nice and simple methods with examples 😄😄😄 thank u for videos

[@vipin2872]

Nicely explained. Mam

[@jf1341]

Very well presented 🙏 👌👌👏👏

[@honestcomments8053]

Excellent video!

[@malhotrapawan9001]

Great👍

[@sutharshansrikumar3001]

Very nice explanation

[@hibasyed7646]

Helpful 👍

[@samirdeshmukh9886]

Very helpful.. thank you..✨

[@yokeshviswanathan1220]

amazing what a voice and you are explanation also awesome keep going

[@sonukumar-pr2nc]

achha pdhati ho, keep it .

[@user-pe9wc7ig2i]

Great explanation, thank you, dear

[@ajinkya820]

You have a wonderful soft voice ..

[@manikantatatvamasi7804]

NIcely explained, Thank you

[@SureshKumar-ug4ep]

Very nicely explained! and your voice is soooo sweet!
Keep it up👍

[@poojatiwari6290]

Nice way of explaining 👍

[@gauravrawat5521]

Your notes are so well define easy to understand

[@crackconcepts]

Hi, please watch the below linked video to understand the difference between WHERE and HAVING even better.
ruclips.net/video/ggBXefD4UT8/видео.html
✨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)

[@bhuvananithu1466]

. mn

[@ramireddygopalreddy4316]

how to contact u mam

[@afuhcyrilcheuck5032]

I need help , the other video you made explaining how you to find the second highest salary with MAX . It was
Select MAX(salary) from employee
Where salary < ( select Max
(Salary) from employee ). Thats using an aggregated function with "where "which you just said otherwise

[@balanagadurgasrilakshmi8562]

Hii I want to
Take course from you how can I contact you pls

[@sumityerme3811]

Thanku mam

[@harshalpatil2009]

Informative

[@JinkaJayakrishna]

Mam the way of explanation is super thanks for given valuable classes

[@hadireg]

Having is the only solution giving you the option to filter on the results of the aggregate function. Where can still be used on the other fields of the dataset before the aggregate functions are processed.

[@varunwadekar7]

very helpful for the interview preparation

[@Jooockerx]

Nice and clear explanation, thank you very much from south yemen.

[@narenderuggera1972]

I became fan of your voice nd thanks for the most common interview question explained in great manner👍👍👍🙏

[@manikandan-hz8yd]

🤣🤣🤣🤣🤤🤤

[@tanvir7783]

Men is always men

[@leisuretime8023]

(meanwhile in the background I heard)
Pyar ki raah mein chalnaa seekh....

[@Mohammed-up8lg]

Creep spotted 😂😂😂

[@narenderuggera1972]

@@tanvir7783 🙏

[@shreyasjadhav7323]

Thanks for this video ...

[@sivareddyalavala4425]

Good explanation

[@letsdoit6438]

Excellent explanation

[@harshsugandhi07]

Nicely explained 🔥

[@AshokKumar-fm7xb]

Good job 🙏

[@bollywoodupdates1706]

Thank you for the video!

[@NikitaSharma-bs4gg]

Thanks - was so helpful

[@netwkeng7101]

You are doing great job sister with husky voice

[@Rohitkumar-vq1yk]

Thank you this has helped me a lot

[@amanbhargava2702]

Thank you sadia

[@jvinaykumar3274]

Awesome voice and good explanation 😍

[@ashutoshgaur8105]

very nice voice, explained in good way

[@mushiburrahamanmallick3372]

excellent

[@leadprogrammer]

You do great efforts, aggregating those neatly written paper docs. It would require lot of hard work.
Please give a try to ms word where changes or corrections also would be easier for you.
And Mysql database with ms workbench which is opensource, would save your time and your efforts a lot.
Great work, you would come up with flying colours. Best of luck...

[@RahulGupta-fk4cz]

Mam your voice is so sweet and the way of your teaching is also good

[@A4Abhinav]

Awesome video

[@tanushreenagar3116]

Nice mam 👍 thanks 😊

[@kailastapase33]

Your really great

[@abhishekpandey4660]

Short,simple and clear explanation.. Really liked it so much:)

[@crackconcepts]

Thank you so much!

[@ashokchandra4911]

Nice tutorial didi

[@ditasusilawati718]

Makasih banyak mbak e. Ini membantu aku di ujian

[@nishanthgaddam8426]

We can use where clause and having too because we can filter non aggregated value and having count(emp_id)>=1 . Instead of using having emp_id>105 u shld have use where emp_id>105

[@crackconcepts]

Correct. Made a mistake there. Thanks for correcting! :)

[@nishanthgaddam8426]

@@crackconcepts No worries and thank you for educating us 😀😊

[@ajinkya-eigteen5144]

Thank you so much ....love you

[@snuffshot9287]

Thank you 🙏

[@ARPITTHEIRONMAN]

very nicely explained

[@piyushkapil9598]

Thanku so much please make more videos

[@parthasarathyraja8917]

Volume of teaching can be increased to hear well and understand.Thank you

[@nicomentes156]

Thank you very much!

[@animoki9292]

Nice sister..Good

[@yoshitamahajan353]

Thanks!

[@SanjaySharma-rl3xu]

This is nice!

[@SanjaySharma-rl3xu]

We can use where when using group by also.

[@chaithanyagosangi8950]

mam, please note the correction that, where can be used in your explanation for id, having is only used for aggregated filters.