SQL Group By: An Explanation and How To Use It
Details
| Title | SQL Group By: An Explanation and How To Use It |
| Author | Database Star |
| Duration | 5:04 |
| File Format | MP3 / MP4 |
| Original URL | https://youtube.com/watch?v=x2_mOJ3skSc |
Description
📝 Get my free SQL Cheat Sheets: https://databasestar.mykajabi.com/lpkj-sql-cheat-sheets/?video=x2_mOJ3skSc
🎓 Master SQL Fundamentals: https://databasestar.mykajabi.com/sql-simplified/?video=x2_mOJ3skSc
The SQL GROUP BY keyword is a powerful feature that lets you summarise data from your query into groups.
This can be helpful to see the number of employees in a department, or the total value of sales per month, and much more. Any time you need "something PER something else", it's often done with an SQL Group By.
In this video, you'll learn what Group By is, a step-by-step process on how to write one, what happens if you don't include Group By, and some examples.
Timestamps:
00:00 Start
00:09 What is Group By?
00:30 Sample table
00:49 First query
01:34 Group By question
01:46 Start a Group By query
02:37 Add an Order By
03:04 Can we exclude Group By?
03:59 Using another aggregate function
