SQL Server Queries Part 10 - GROUP BY and HAVING
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this link https://www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching!
By Andrew Gould
https://www.wiseowl.co.uk - Learn how to group data and calculate aggregate statistics in Microsoft SQL Server queries. This video teaches you how to use the GROUP BY clause in a query to organise your data into groups, including how to group by multiple columns in the same query. We'll also show you how to make use of the aggregate functions to calculate values such as the total and average of a range of numbers, including how to apply totals and subtotals using the ROLLUP keyword.
You can download the script to create the Movies database used in this video at the following link:
https://www.wiseowl.co.uk/files/execise-question-files/qf-898.zip
You can see a written version of this tutorial at:
https://www.wiseowl.co.uk/blog/s331/group-by.htm
You can see the range of resources and courses we offer in SQL Server here:
https://www.wiseowl.co.uk/sql/
Visit www.wiseowl.co.uk for more online training resources in Microsoft Excel, Microsoft Access, Microsoft PowerPoint, Microsoft Word, Microsoft Project, Microsoft Publisher, Microsoft Visio, SQL Server, Reporting Services, Analysis Services, Visual Studio, ASP.NET, VB.NET, C# and more!
Видео SQL Server Queries Part 10 - GROUP BY and HAVING канала WiseOwlTutorials
By Andrew Gould
https://www.wiseowl.co.uk - Learn how to group data and calculate aggregate statistics in Microsoft SQL Server queries. This video teaches you how to use the GROUP BY clause in a query to organise your data into groups, including how to group by multiple columns in the same query. We'll also show you how to make use of the aggregate functions to calculate values such as the total and average of a range of numbers, including how to apply totals and subtotals using the ROLLUP keyword.
You can download the script to create the Movies database used in this video at the following link:
https://www.wiseowl.co.uk/files/execise-question-files/qf-898.zip
You can see a written version of this tutorial at:
https://www.wiseowl.co.uk/blog/s331/group-by.htm
You can see the range of resources and courses we offer in SQL Server here:
https://www.wiseowl.co.uk/sql/
Visit www.wiseowl.co.uk for more online training resources in Microsoft Excel, Microsoft Access, Microsoft PowerPoint, Microsoft Word, Microsoft Project, Microsoft Publisher, Microsoft Visio, SQL Server, Reporting Services, Analysis Services, Visual Studio, ASP.NET, VB.NET, C# and more!
Видео SQL Server Queries Part 10 - GROUP BY and HAVING канала WiseOwlTutorials
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
SQL Server Queries Part 11 - SubqueriesAdvanced Aggregate Functions in SQL (GROUP BY, HAVING vs. WHERE)Learn Basic SQL in 15 Minutes | Business Intelligence For Beginners | SQL Tutorial For BeginnersAggregate Functions, Group by Clause and Having Keyword in SQL ? | SQL Server Interview QuestionsSQL performance tuning and query optimization using execution planGroup by in sql server - Part 11SQL Server Queries Part 12 - Correlated SubqueriesUse Of GROUP BY Clause In SQL | Interview Questions | ExamplesSQL Server Programming Part 5 - IF StatementsSQL WITH Statements (Common Table Expressions - CTE)SQL Server Queries Part 6 - JOINS (Inner and Outer Joins)Views in sql server Part 39SQL functions, GROUP BY, ORDER BY, DISTINCT --- SQL for data science tutorial EP#2 (for beginners)SQL Server Programming Part 13 - Dynamic SQLSQL Server Programming Part 17 - The Pivot OperatorSQL Server Queries Part 1 - Writing Basic QueriesSQL Tutorial 7: Group By, Having & ,Order By Clauses in SQLSQL Server Queries Part 3 - WHERE (Criteria in Queries)How To Solve SQL Problems