The Difference Between WHERE and HAVING

The Difference Between WHERE and HAVING | WHERE vs. HAVING in SQL

Рет қаралды 2,196

Жыл бұрын

Explaining the theoretical and practical difference between the SQL keywords WHERE and HAVING. Let me know whether you want me to go through more SQL keywords and concepts such as window functions, date manipulations etc.
Find me on LinkedIn: / frederikmueller
LeetCode 596:
• LeetCode 596: Classes ...
leetcode.com/problems/classes...
StrataScratch 10315:
• Real SQL Interview Que...
platform.stratascratch.com/co...
Alex the Analyst video:
• Intermediate SQL Tutor...
w3schools and Microsoft resources:
www.w3schools.com/sql/sql_hav...
learn.microsoft.com/en-us/sql...
Playlists:
StrataScratch SQL Coding Questions: • StrataScratch Coding Q...
LeetCode database SQL problems: • LeetCode Database Prob...
LeetCode easy SQL problems: • LeetCode Easy Database...
LeetCode medium SQL problems: • LeetCode Medium Databa...
LeetCode hard SQL problems: • LeetCode Hard Database...

Пікірлер: 10

@user-jz3vz4gp9y Жыл бұрын

Great to see you back again, you were huge for teaching me sql and making me better at sql

@SATULAL Жыл бұрын

I'm learning SQL and I literally just thought about this issue yesterday! Great timing.

@beingcheercool Жыл бұрын

I just love you videos 😍 Keep growing man!!

@amanmehrotra44 Жыл бұрын

I think it's almost after 3 months since you made this video buddy. Please keep making such videos. The day after I saw your last posted video, I was like - "Man, what would I do from tomorrow to advance further in SQL". Thanks once again for such gem content. :)

@christoslefkimiotis9889 Жыл бұрын

Very good explanation. The way you got around using a subquery was nice.

@frederikmuller Жыл бұрын

Thank you! Maybe that’s the point of using HAVING, after all.

@atmaj4244 Жыл бұрын

I started learning SQL in Google Data Analytics course its been 1 month, I can use BasicSQL functions with filters which site you recommend to practice

@frederikmuller Жыл бұрын

Do the Hackerrank SQL gold badge and then move on to LeetCode and StrataScratch questions.