Writing SQL for Excel with ADODB playlist https://youtube.com/playlist?list=PLNIs-AWhQzckUd5i0E1xeSFeBAonYIurK
VBA Working with Databases playlist https://youtube.com/playlist?list=PLNIs-AWhQzclbRVLCZlsFvpz6fz2nPGbt

Get files here https://www.wiseowl.co.uk/vba-macros/videos/vba-ado-net-recordsets/sql-excel-grouping-rows/

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!

This video explains how to group rows in your SQL queries for Excel files by using the Group By clause. You'll learn how to group data using the values in a column and how to create aggregations using functions such as Sum, Avg and Count. You'll also see how to group data using the results of calculations and how to create multiple row groups.

Chapters
00:00 Topic List
00:33 The Basic Setup
02:39 Summing a Column
04:03 Adding a Group By Clause to a Query
05:19 Adding More Aggregation Columns
07:33 Sorting by Aggregated Values
09:40 Adding Criteria to Rows
12:26 Grouping on Multiple Fields
14:20 The Order of Columns
15:52 Grouping on Calculated Values
19:04 Grouping on Multiple Calculations
21:36 Grouping by Year
23:06 Sorting by Grouped Expressions
24:03 Grouping by Year and Month
25:44 Sorting by Month Number
27:57 What's Next?

Visit www.wiseowl.co.uk for more online training resources in Microsoft Excel, Power BI, DAX, SQL Server, Reporting Services, Analysis Services, Integration Services, ASP.NET, C#, Visual Basic, Microsoft Access and more