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 ..

[@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]

th-cam.com/video/QTaiF8N6i3Y/w-d-xo.html🙏🏻🙏🏻

[@chilly2171]

This TH-camr has no idea what she is talking about man....

[@rameshmalhotra9525]

th-cam.com/video/p0gL1pAhGZE/w-d-xo.html

[@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

[@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]

th-cam.com/video/p0gL1pAhGZE/w-d-xo.html

[@vaishalidharmik2038]

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

[@suhailahamed7514]

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

[@gauravnegi4312]

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

[@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.

[@tekieogubagabir43]

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

[@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.

[@deepakpandey9406]

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

[@vivamedia5958]

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

[@archanapbhat5232]

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

[@Faisal1504]

Thanks for sharing very well explained

[@shreyjainhere]

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

[@rohanmali6583]

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

[@vS-mn9id]

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

[@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!!

[@kumarakrish3976]

Proper explanation with great presentation 😊

[@Sam_yemjala]

What a voice dude , damn pleasant

[@bootexcel5122]

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

[@gauravghosh8002]

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

[@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 🙏

[@anunutan9220]

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

[@shahzan525]

Most usefull .....
Great work 👍

[@331sairam]

Straight concept clear voice ....cool

[@ajinkya820]

You have a wonderful soft voice ..

[@shreyasjadhav7323]

Thanks for this video ...

[@anujlovetube]

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

[@SameerShaikh-ty5zt]

Thank you.. Your way of explaining is sweet.

[@ajajjamadar]

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

[@buildtolearn]

Love these videos. Great job!

[@gauravrawat5521]

Your notes are so well define easy to understand

[@manognakarimi]

To the point ,
helped me.
Thank you 😀

[@Kamil0289]

Simply explained, thank you :)

[@bollywoodupdates1706]

Thank you for the video!

[@amanbhargava2702]

Thank you sadia

[@sutharshansrikumar3001]

Very nice explanation

[@NikitaSharma-bs4gg]

Thanks - was so helpful

[@user-pe9wc7ig2i]

Great explanation, thank you, dear

[@vijaypanchal7344]

Nice tutorial and clear voice to understand.

[@samirdeshmukh9886]

Very helpful.. thank you..✨

[@Rohitkumar-vq1yk]

Thank you this has helped me a lot

[@honestcomments8053]

Excellent video!

[@tariqzaman2077]

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

[@virendrabhati6685]

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

[@yasmeenhasan9925]

Thanks for the making videos! Its very very helpful

[@Jooockerx]

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

[@zaidzeee]

Amazing work keep it up

[@malhotrapawan9001]

Great👍

[@JinkaJayakrishna]

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

[@harshalpatil2009]

Informative

[@mukulverma9966]

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

[@manikantatatvamasi7804]

NIcely explained, Thank you

[@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 😀😊

[@letsdoit6438]

Excellent explanation

[@vminkook_lover782]

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

[@hibasyed7646]

Helpful 👍

[@sonukumar-pr2nc]

achha pdhati ho, keep it .

[@snuffshot9287]

Thank you 🙏

[@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 ......🤗🤗🤗🤗🤗🤗🤗

[@varunwadekar7]

very helpful for the interview preparation

[@poojatiwari6290]

Nice way of explaining 👍

[@tanushreenagar3116]

Nice mam 👍 thanks 😊

[@prashantp9029]

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

[@chaithanyagosangi8950]

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

[@sivareddyalavala4425]

Good explanation

[@jf1341]

Very well presented 🙏 👌👌👏👏

[@itdp.warangal]

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

[@unknowns9500]

we can use where instead of having , we use having when we place the group by clause

[@nelikantinagaraj4866]

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

[@CodeWithFiroj]

Good one.

[@ashutoshgaur8105]

very nice voice, explained in good way

[@vipin2872]

Nicely explained. Mam

[@nicomentes156]

Thank you very much!

[@ajinkya-eigteen5144]

Thank you so much ....love you

[@AMITVISHWAKARMA-dy2wi]

When we use max() function still we can use the where clause it works.

[@kmrajesh1686]

Yes

[@sourabhgupta9095]

Yes but it should be before having clause

[@vinnu.gamer.2096]

Yes even I wondered when she said that .. I do it daily...

[@vivekpuri-08]

What she said is exactly what I found on w3schools.

[@little_prince_official]

We can use it on to find maximum values in the database

[@RahulGupta-fk4cz]

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

[@netwkeng7101]

You are doing great job sister with husky voice

[@harshsugandhi07]

Nicely explained 🔥

[@sivakys]

Thank you very much 🤩

[@yokeshviswanathan1220]

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

[@divyaalok5538]

Thank you

[@AshokKumar-fm7xb]

Good job 🙏

[@yoshitamahajan353]

Thanks!

[@kailastapase33]

Your really great

[@bhushandatey5792]

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

[@parthasarathyraja8917]

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

[@mushiburrahamanmallick3372]

excellent

[@ashokchandra4911]

Nice tutorial didi

[@prakashvish3988]

Very mild n cute voice ❤️

[@ARPITTHEIRONMAN]

very nicely explained

[@A4Abhinav]

Awesome video

[@jvinaykumar3274]

Awesome voice and good explanation 😍

[@piyushkapil9598]

Thanku so much please make more videos

[@vijayarahavanrajagopal6885]

Aggregate function
It is used to multiple rows of single column

[@SureshKumar-ug4ep]

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