Important SQL INTERVIEW question | Difference between where and having in mysql

Рет қаралды 43,656

Күн бұрын

𝐖𝐚𝐧𝐭 𝐭𝐨 𝐌𝐚𝐬𝐭𝐞𝐫 𝐒𝐐𝐋? 𝐋𝐞𝐚𝐫𝐧 𝐒𝐐𝐋 𝐭𝐡𝐞 𝐫𝐢𝐠𝐡𝐭 𝐰𝐚𝐲 𝐭𝐡𝐫𝐨𝐮𝐠𝐡 𝐭𝐡𝐞 𝐦𝐨𝐬𝐭 𝐬𝐨𝐮𝐠𝐡𝐭 𝐚𝐟𝐭𝐞𝐫 𝐜𝐨𝐮𝐫𝐬𝐞 - 𝐒𝐐𝐋 𝐂𝐡𝐚𝐦𝐩𝐢𝐨𝐧𝐬 𝐏𝐫𝐨𝐠𝐫𝐚𝐦 𝐛𝐲 𝐒𝐮𝐦𝐢𝐭 𝐒𝐢𝐫!
"𝐀 8 𝐰𝐞𝐞𝐤 𝐏𝐫𝐨𝐠𝐫𝐚𝐦 𝐝𝐞𝐬𝐢𝐠𝐧𝐞𝐝 𝐭𝐨 𝐡𝐞𝐥𝐩 𝐲𝐨𝐮 𝐜𝐫𝐚𝐜𝐤 𝐭𝐡𝐞 𝐢𝐧𝐭𝐞𝐫𝐯𝐢𝐞𝐰𝐬 𝐨𝐟 𝐭𝐨𝐩 𝐩𝐫𝐨𝐝𝐮𝐜𝐭 𝐛𝐚𝐬𝐞𝐝 𝐜𝐨𝐦𝐩𝐚𝐧𝐢𝐞𝐬 𝐛𝐲 𝐝𝐞𝐯𝐞𝐥𝐨𝐩𝐢𝐧𝐠 𝐚 𝐭𝐡𝐨𝐮𝐠𝐡𝐭 𝐩𝐫𝐨𝐜𝐞𝐬𝐬 𝐚𝐧𝐝 𝐚𝐧 𝐚𝐩𝐩𝐫𝐨𝐚𝐜𝐡 𝐭𝐨 𝐬𝐨𝐥𝐯𝐞 𝐚𝐧 𝐮𝐧𝐬𝐞𝐞𝐧 𝐏𝐫𝐨𝐛𝐥𝐞𝐦."
𝐇𝐞𝐫𝐞 𝐢𝐬 𝐡𝐨𝐰 𝐲𝐨𝐮 𝐜𝐚𝐧 𝐫𝐞𝐠𝐢𝐬𝐭𝐞𝐫 𝐟𝐨𝐫 𝐭𝐡𝐞 𝐏𝐫𝐨𝐠𝐫𝐚𝐦 -
𝐑𝐞𝐠𝐢𝐬𝐭𝐫𝐚𝐭𝐢𝐨𝐧 𝐋𝐢𝐧𝐤 (𝐂𝐨𝐮𝐫𝐬𝐞 𝐀𝐜𝐜𝐞𝐬𝐬 𝐟𝐫𝐨𝐦 𝐈𝐧𝐝𝐢𝐚) : rzp.io/l/SQLINR
𝐑𝐞𝐠𝐢𝐬𝐭𝐫𝐚𝐭𝐢𝐨𝐧 𝐋𝐢𝐧𝐤 (𝐂𝐨𝐮𝐫𝐬𝐞 𝐀𝐜𝐜𝐞𝐬𝐬 𝐟𝐫𝐨𝐦 𝐨𝐮𝐭𝐬𝐢𝐝𝐞 𝐈𝐧𝐝𝐢𝐚) : rzp.io/l/SQLUSD
𝐖𝐚𝐧𝐭 𝐭𝐨 𝐥𝐞𝐚𝐫𝐧 𝐁𝐢𝐠 𝐃𝐚𝐭𝐚 𝐛𝐲 𝐒𝐮𝐦𝐢𝐭 𝐒𝐢𝐫?
𝐜𝐡𝐞𝐜𝐤𝐨𝐮𝐭 𝐭𝐡𝐞 𝐛𝐢𝐠 𝐝𝐚𝐭𝐚 𝐜𝐨𝐮𝐫𝐬𝐞 𝐝𝐞𝐭𝐚𝐢𝐥𝐬
𝐖𝐞𝐛𝐬𝐢𝐭𝐞 : trendytech.in/?src=youtube&su...
I have trained over 20,000+ professionals in the field of Data Engineering in the last 5 years.
In this video we will talk about the difference between WHERE and HAVING clause in MYSQL. This is a very important question from interview point of view also.
Do Like, Comment & Subscribe :)
𝗝𝗼𝗶𝗻 𝗺𝗲 𝗼𝗻 𝗦𝗼𝗰𝗶𝗮𝗹 𝗠𝗲𝗱𝗶𝗮:🔥
🔅Sumit LinkedIn - / bigdatabysumit
🔅Sumit Instagram - / bigdatabysumit
Where vs Having clause in SQL
==============================
select source_of_joining,count(*) as total from students group by source_of_joining;
I want to know the lead sources through with more than 1 person has registered.
select source_of_joining,count(*) as total from students group by source_of_joining where total gt 1;
where clause is used to filter the individual records before aggregation..
select source_of_joining,count(*) as total from students group by source_of_joining having total gt 1;
// I want to know the count of people who registered through linkedIN
select source_of_joining,count(*) as total from students group by source_of_joining having source_of_joining = 'linkedin';
select source_of_joining,count(*) as total from students where source_of_joining = 'linkedin' group by source_of_joining;
can we use where and having in same query
==========================================
//the locations from which more than 1 student has joined & the students experience is more than 10 years
select location,count(*) as total from students where years_of_exp gt 10 group by location having total gt 1;
where is used before group by and do filtering on individual records
having is used after group by and do filtering on aggregated records.
we can use where and having in the same query also.
where is more performant than having.
#SQL #RDBMS #database #bigdata #dataengineering

Пікірлер: 37

@sumitmittal07 Жыл бұрын

Checkout the Big Data course details here: trendytech.in/?referrer=youtube_sql13

@rahultewari8354 Жыл бұрын

sir in last query if we also want to print years_of_exp then what will we do . select location,years_of_exp,count(*) as total from student where years_of_exp>10 group by location having total>1; # its giving error

@arnabpati2724 Жыл бұрын

@@rahultewari8354 the corrected query will be: select location, years_of_exp, count(*) as total from students where years_of_exp > 10 group by location, years_of_exp having total > 1; It will not give any error but can give null if no such records are present or exist.

@bharathKumar-or6gd Ай бұрын

Clear and Great Explanation on Where and Having Clause 👌👌👌👌

@rashmibhardwaj1254 Жыл бұрын

I couldn't find this much clarity in any of the explanations available on the internet. 🙂

@greatmonk Жыл бұрын

Thank you Sir.. This was a wonderful session.. You have rightfully curated the program and touch-based the missing points.. Thank you again!!!!!!!!

@smyphysics 2 жыл бұрын

Great sir (SQL session 12 _Difference between where and having in mysql)

@farzicoder8905 2 жыл бұрын

What a great explanation, that made it crystal clear.

@vishnujatav6329 2 жыл бұрын

Very much useful. Thanks a lot

@amanhayaran1152 Жыл бұрын

nicely and clearly explained sir Loved this series

@TrustinData Жыл бұрын

Awesome explanation sir

@ravimishra339 8 ай бұрын

Awesome explanation.

@sagnikchakraborty734 Жыл бұрын

Sir you are the best teacher I ever learned from....

@khaan119 Жыл бұрын

Have u get job ??

@dkkashyap6494 Жыл бұрын

Undoubtedly one of the best courses.... But due to limitation of dataset its lacking a bit,,,, You should have used the provided schemas in Mysql... just a suggestion\

@ripulchhabra5686 2 жыл бұрын

was waiting ✋

@Kush6542 2 жыл бұрын

thanks a lot sir. very useful

@sumitmittal07 2 жыл бұрын

Happy to hear that you found the content useful :)

@abhishekkatara7584 2 жыл бұрын

Wonderful explanation of both Where and Having clause, liking the entire series Sumit Sir.

@sumitmittal07 2 жыл бұрын

I am happy to hear that you are liking the explanation :)

@saurabhpandey7603 2 жыл бұрын

Good explanation

@sayalipatkar2755 2 жыл бұрын

great videos

@poojachavan4091 9 ай бұрын

thank you sir

@chanduyj 7 күн бұрын

Sir can you please share the notes which you were saved in your notepad while Explaining

@santoshatyam1409 Жыл бұрын

We can't use alias name in having clause such as total. Why it is not throwing error in SQL server it will give error

@harshrajvaghela699 2 жыл бұрын

sir plese roll about cloud computing in big data

@aakashsrivastava9808 Жыл бұрын

hello sir i have a followup question regarding the last query .. select source_of_joining,count(*) as total from employee where exp>3 group by source_of_joining having total>2; this query chaecks the source_of_joining having total >2 after filtering exp>3 what if we want to check the source_of_joining having total >2 and after that check exp>3.. I am trying to do it like this but it is showing errror select source_of_joining,count(*) as total from employee group by source_of_joining having total>2 where exp>3;

@nitinrao1133 Жыл бұрын

No, this is won't work like the way yu want to execute. Where always execute before the group by statement.

@therisingsinger4330 4 ай бұрын

@@nitinrao1133 correct 💯

@therisingsinger4330 4 ай бұрын

Is anyone can please tell me , why there is applied ... Having total >1; I got confused

@ashishthakur8619 Жыл бұрын

Can we get the document that u used

@NAVEENKUMAR-nd7jg Жыл бұрын

happy ending cool sir cool my god live long?

@khaan119 Жыл бұрын

Have u get job help with this sql course

@sharmisaha9655 2 жыл бұрын

self join is not covered

@satyajeet4450 2 жыл бұрын

Q1a. Display the total no. of students joined from each source & the lead sources through which more than 1 person has registered ----> SELECT source_of_joining,count(*) AS TOTAL from students GROUP BY source_of_joining HAVING TOTAL > 1; b. Display the count of people who registered through linkedIN. ----> SELECT source_of_joining,count(*) AS TOTAL from students GROUP BY source_of_joining = 'linkedIN'; Q2. The locations from which more than 1 student has joined & students having more than 10 years of experience. ----> SELECT location, count(*) AS TOTAL from students where years_of_experience > 10 GROUP BY location HAVING TOTAL > 1;

@tashi9154 Жыл бұрын

Q1. b is incorrect ig