Master the SQL SELECT statement part 06: Aggregate Functions, GROUP BY and HAVING clauses
HTML-код
- Опубликовано: 19 июн 2024
- This video is part of a multi-part series on mastering the SQL SELECT statement. The SELECT statement, the most often used SQL command, is easy to learn yet difficult to master. Follow along with me and level up your database query super powers!
This video covers the Aggregate Functions, GROUP BY, and HAVING clauses, specifically
- Counting rows, values in columns, and unique values in columns
- Getting sums, minimum, maximum, and averages.
- NULL handling of the aggregate functions.
- The purpose of GROUP BY
- Understanding why columns in the projection (SELECT line) must be in the GROUP BY when an aggregate it used.
- Using the HAVING clause to filter rows after the GROUP BY operation.
- Differences between HAVING and WHERE
The SQL code is available here: github.com/mafudge/learn-data...
If you need to setup your own database environment, check out learn-databases! The easy way to get going and follow along with these videos. • Learn Databases Walkth...
This video is part of the textbook Applied Database Management applieddb.com
Here's the entire playlist: • Applied Database Manag...
Based on COUNT(views), I will say your video is very underrated.
After watching over 10 videos, this video is by far the best explaining Group By. Thanks 🙏
This is is the best video I have watched on GROUP BY. Sharing with my DBMS class :)
Crystal clear, thanks 🏅
Thank you this has been BEYOND helpful. Im so happy to have found and instructor that actually explains WHY a certain action/step needs to happen in the format it does and not just the HOW. Seeing the visual of the table really helps with the comprehension.
Most energetic tutor I ever came across on YT. Thanks for sharing knowledge.
this was awesome, i was spinning in circles trying to grasp group by w/ having and this video really helped!
I can't thank you enough, this was supper helpful
Thank you
Wow quality content. But hardly 500 views. Subbed you.
Thank you. It takes a while to get noticed!
Woah I finished a 30min video tutorial! Thanks man, this is really helpful and interesting.
Such a good explanation! Thank you.
thanks Michael!
This was incredibly helpful! Thank you so much!!!
This was a fantastic video. I learned a ton! Thank you.
Extremely helpful! You’re a legend
I'm start to learn mysql and you help me a lot. Was wondering about count row vs count column and you have explained them very clear. Thank you.
Great explaination! This helped me a lot! Thanks
Thanks alot..this is clear and for the first time, I clearly understand basics of sql aggregations and having clause
amazing videos, thank you so much
Thank you for sharing ur knowledge..From..🇳🇵..Nepal
🎉 Very informative video, learned a lot, thanks
Thanks!
Thanks this are great.
loved it
Great video! I've seen and used things like count and group by but never understood how they really work. The examples in this video are practical and well explained! The pace was perfect. I felt like I was continuously building knowledge throughout every part of the video.
I am happy I was able to help you out!
Cela fait des jours que je cherche un tutoriel pour comprendre cette partie et j'ai tout compris ici. Merci
I like the look on your face @2:10 lol
Thank you for the video!!
Where can I get the database to practice with you?
👍👍👍👍
How do I sum alias column?
I wish you guys would use dark mode and zoom in so we can see what ur writing 🙄 as soon as i see a white screen with the font a thousand miles away from my eyes, i click off, but this time i wanted to leave a comment cause it keeps pi$$ing me off