Difference Between WHERE and HAVING in SQL With Examples | Most Important Interview Question

Today's video, we'll discuss the difference between WHERE and HAVING clause in SQL.
difference between where and having in sql server, where clause and having clause in sql explained with an example, difference between Having and Where Clause in SQL with example, where vs HAVING clause, SQL Interview Question, Must do SQL Interview Question.

[@crackconcepts]

Hope this video helped y’all.
This is a question which a lot of you were confused about, so here’s the video.
SUBSCRIBE TO HELP SUPPORT THE CHANNEL. THANKS 🙏

[@anzimk1620]

Thank you so much maam.. Am new her... Ur Best

[@RAVISINHA-jd9wq]

Can We get videos on Java Concepts?

[@kshtriyapride5124]

Thank you so much

[@Amankumar-gp7su]

Just a note : People say that HAVING cannot exists without group by ,but this is wrong. Having can exists without GROUP BY.when HAVING alone is used it's compulsory to use aggregate function. In the absence of group by HAVING will group entire table as one and applies aggregate function .
Apart from it , well explained ,really liked it!!

[@sadiahafeez1991]

Can we use having clause without aggregate function in group by clause?

[@akashthakare2425]

Your video's are good. I just started watching it and it is really helpfull.
But I think if you use table and record that will help me more to clear concept. That's what I think and one's again thank you for making videos.

[@sandeepparambath4469]

Thanks for this simple and understanding writing in the paper, short videos which were really helpful to understand the concepts.:)

[@raginikumari2290]

It was easily understandable, very neat and clean explanation with sweet and soft voice.. Thank you for your efforts.

[@asthasingh155]

Please do mention the SQL question for which you are creating the SQL queries, that helps more in understanding the condition (in WHERE and HAVING) and fields being pulled in your queries.... Thanks! Great videos..

[@jithin7822]

Please do more on SQL query examples asked in interviews

[@nayanshirose9866]

Thank you so much ma'am it is very easy to understand for me . Your video is very useful. Thanks again ma'am

[@LordNegativePrime]

Thanks a lot for making this videos, this help me a lot, you are awesome, greetings from Mexico.

[@VinodKumar-ft1uc]

Hey Hi..!
Its very Nice of you making videos by topic wise with Examples . Keep Going..!

[@upendarreddy049]

Thank you for making the best videos all the time. Please make a video on sql query optimization

[@TylerNicoleTaylor_]

Thank you! You explain things very well- concise but understandable. Please keep posting!

[@akshaychaudhari1529]

Hello I like youre all video ...
Can you make video plz About ROWNUM ,partions.,over disting,
And practical run...just as demo 🙏
And youre all video nice 👍keep it up ..

[@javjersey]

SOOOO INFORMATIVE AND CLEAR!! I get it now 😁😁Love your videos!!! Thank you from America!!🙏🏼🙏🏼🙏🏼

[@ffproplayershere]

Udhar ja ke bhi idhar ke video dekh raha hai😅😅😂

[@AA-qd6xm]

It's day 1, I watched ur videos n it's amazing. Nice way to use Knowledge with dedication by using simple method to achieve great success...God bless you...keep it up...

[@datavizenthusiast3560]

wonderful lady ! thanks a lot !

[@luiscastillo2610]

the best explicacion i have ever seen until now, thanks to this asian woman

[@vasimuddinsheikh3766]

Be more specific... INDIAN

[@arbazkhan-od9sk]

I wish I found your videos earlier awesome explaination... keep up the good work

[@hayathbasha4519]

Useful one
Learned something today 😇

[@shahrukhahmad4127]

Thank you for short and easy explanation. God bless you ❤️

[@indian7082]

Iam very much happy for your explanation 👍.
Could you please prepare a video like joins . I got many interviews failed during sql only. Just now i subscribe your channel.

[@madhusudhanreddy8656]

Your explanation is really awesome....Thank you so much❤

[@akash_mishra565]

Very well explained.. Thanks ❤️

[@prasadyadav5759]

Awesome all doughts clear
Thnx for the video👍👌

[@charithgunathilaka]

great help with sql groups

[@chakripalagorla9511]

Yes Thank you i understand clearly

[@nikitajaiswal9112]

Best explanation in simple language

[@patanshabbir8489]

Thanks. Nice explanation of concept.

[@karamveersingh8532]

Nice explanation. Thank you

[@vishnuvamshi4645]

Make video on Difference between group by and partition by

[@thefacts3627]

thankyou didi for so beautiful explaination

[@pranavbakare8922]

Cleared information Keep sharing......

[@shamrajshan4355]

Really helpful to me nice explanation

[@zt81]

you are great at explaining!

[@akshaychaudhari1529]

Delete duplicate rows from table ...
How...plz sol this Question.. I try so many qurry but not run do you have any simple way...

[@pavanbc3106]

In a table there won't be any duplicate rows as I know

[@adityajacob2246]

This was very helpful..thank you

[@cmpunk8823]

Thank you so much 🙂

[@yogeshwaran1917]

Hi....
Plz give some examples of
Power BI
Database
Group By
Order By
Bcz....of....interview qns.....

[@shiruc1168]

Your voice💕💕 thanx for teaching

[@pavanbc3106]

Thanks mam🎉

[@rohitvijaywaghmare632]

Best explaination in simple language.. thank u🤙🤙🤙

[@meetvakani6734]

Amazing. Thank you

[@sopankardile2603]

Thank you so much

[@dogukansahin4865]

it was pretty clear, thanks

[@loganmilkman7009]

Thanks for the video!

[@gamingbomber-g3q]

Great mam👍
Keep doing good job

[@higa4541]

Thankq thankq thankq sooo much ❤️🙏

[@Createsofkaira19024]

What is diff like sal

[@sumityerme3811]

Thanx Sadia mam

[@snehalmagdum878]

You are amazing 🤩

[@saurabhsawarkar3263]

3 year old video but best explanation

[@praneethk3554]

Thanks Mam ! Wonderful explanation

[@vikashr.dharmaratne3330]

Thank you

[@abhinavmishra7617]

Good explanation

[@mohsindkp3204]

You should mention table too

[@jawariaalvi627]

Please also make videos on mongodb

[@anuragbawankar685]

Thanks a lot !!!

[@AmitGupta-fd3zy]

Thank you mam

[@jeyhunaliyev1765]

just awesome

[@rk-ej9ep]

Great

[@MoodyVideoGraphies]

u r awsome.

[@sivakrishnakongala5930]

having count >5000, means we will get data, if the same data(dup) is more than 5000 is it correct?

[@omkarmore7017]

Is this grouping single column data grouping or multiple column grouping

[@maheshhari1226]

select * from emp_bang
where exists(select job from emp_hyd where emp_hyd.eid = emp_bang.eid );
please explain this step by step madam......pls pls

[@nagarajanerode]

The having query shown should have the SUM(sal) i think

[@educated.zombie]

is there any way i can join simple join two tables , like just attach them side by side , no similarities no reference keys nothing just attach them side by side

[@ramakrishnasamala4201]

well expalined

[@khushboogupta3585]

Hi, I have a quick question for getting the exact query for the following question:
Product_Name , Product_Category , Date_of_sale
---------------------------------------------
iphone7 Mobile 2017-10-01
Samsung S8 Mobile 2017-10-02
Fasttrack Watch 2018-01-03
Titan Watch 2018-01-02
Samsung S8 Mobile 2018-01-05
iphone7 Mobile 2018-10-01
Find list of product from each category which are sold latest/recently within that category?
I have tried this query, just wanted to check with you if this is correct:
Select product_name, product_category, date_of_sale
from product_details
where product_category, date_of_sale in
(select product_category, max(date_of_sale) from product_details group by product_category)

[@dssingh9955]

I think there is little mistake but I'm not very sure. Are you working somewhere ?

[@dssingh9955]

Select product_name, product_category, date_of_sale from product_details where date_of sale in ( max(date_of_sale)) from product_details group by product_category)
I think this will be correct but I'm not very sure please let me know if I'm correct or not.

[@vaibhavverma1340]

select product_Name , Product_category, max(date_of_sale)as recent_date from product_details
group by product_Name , Product_category

[@amankumarjha9438]

Hey sadia,why u didn't post any videos from last 1 month?

[@filterbot1229]

It's clear now😻

[@gauravsawant5482]

please share notes also

[@gampashivakumar]

VERY UNDERSTANDING, THANK YOU

[@mouneshts10]

It is very easy to remember thanks for this video

[@DaCom3AK]

Thank you for the concise explanation.

[@Denisfutbol]

go it. Thanks!

[@sanazain2143]

which college you've studied ?

[@punyabikash3624]

Thank you keep going very helpful 👍

[@suyogkale9922]

Very Good for understanding.
But you can explain In hindi and after explaining the point kindly do on practical demo

[@kirangholap1931]

👍👍

[@karthikgolagani6844]

secret sql superstar

[@SuryaPrakash-me2qr]

Good explanation thank you 🙂

[@prasantamajumder888]

Thank you

[@thilagavathya3436]

Nice explanation

[@bhavanikandikondamatam5926]

Thank you🙏🙏

[@efashahira7053]

thanks a lot!!

[@muhammednihas2218]

thank you

[@rupeshingale6849]

Thank you