Advanced Aggregate Functions in SQL (GROUP BY, HAVING vs. WHERE)
In this step-by-step video tutorial, you will learn some more advanced SQL aggregation concepts by using the GROUP BY, HAVING, and WHERE clauses!
Learn about the BASIC aggregation Functions: • Basic Aggregate Functions in SQL (COU...
Queries:
1) Pull aggregate information with the GROUP BY clause: SELECT column1, column2, COUNT(column3) FROM table GROUP BY column1, column2
2) Use the HAVING clause to filter your aggregation: SELECT column1, COUNT(column2) FROM table GROUP BY column1 HAVING COUNT(column2) = 5
3) Use WHERE and HAVING clauses in the same query: SELECT column1, COUNT(column2) FROM table WHERE column1 = 3 GROUP BY column1 HAVING COUNT(column2) = 5
Get the Northwind Database: • How to Load a Sample PostgreSQL Datab...
Support the Channel:
1) Subscribe:
2) DataCamp:
3) Udacity:
Watch video Advanced Aggregate Functions in SQL (GROUP BY, HAVING vs. WHERE) online without registration, duration hours minute second in high quality. This video was added by user Becoming a Data Scientist 07 January 2020, don't forget to share it with your friends and acquaintances, it has been viewed on our site 279,524 once and liked it 8.8 thousand people.