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-having-clause/

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 shows you how to use the Having clause in an SQL query to apply criteria to the results of aggregation functions. You'll learn why you can't add these criteria to the Where clause, how to add the Having clause to a query and how to write criteria based on aggregation functions such as Sum, Avg and Count. As an added bonus, you'll also learn the importance of the phrase Sweaty Feet Will Give Horrible Odours!

Chapters
00:00 Topic List
00:36 The Basic Setup
02:42 Creating Groups and Aggregates
06:10 Applying Criteria to Rows
08:15 Aggregation Functions in the Where Clause
09:15 Criteria in the Having Clause
10:32 Remembering the Keyword Order
11:52 Multiple Criteria in the Having Clause
13:04 Controlling Multiple Criteria
15:39 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