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:

✨If you appreciate my work and would like to donate to support our channel, you can do so here:

[madhurpalsokar]

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

[kunalgandhe]

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

[anvi]

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.

[dipakk]

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

[sartz]

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

[charlesmathews]

I gained confidence from your teaching. Kudos

[suhailahamed]

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

[gauravnegi]

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

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

[tekieogubagabir]

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

[nagoredeen]

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

[rohanmali]

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

[sohailkat]

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.

[deepakpandey]

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

[vivamedia]

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

[chandrassqlbi]

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

[archanapbhat]

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

[vS-mnid]

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

[bootexcel]

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