By Andrew Gould

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-correlated-subqueries

If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can join this channel to get access to perks:
https://www.youtube.com/channel/UCbi5G5PjWBaQUFy7XU_O7yw/join
Or 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 use correlated subqueries to create a variety of useful techniques such as ranking values in a column, calculating running totals and creating year to date totals.

Chapters
00:00 Topic List
00:37 The Basic Setup
02:23 Basic Subqueries
03:09 Creating a Correlated Subquery
05:51 What Does a Correlated Subquery Do
08:25 Adding More Criteria to a Correlated Subquery
09:44 Using a Subquery to Calculate the Maximum Value
11:21 Converting to a Correlated Subquery
12:42 Adding More Criteria
13:29 Returning Multiple Values from a Subquery
14:55 Ranking Values
17:51 Ranking Grouped Values
19:02 Creating a Grouped Query
21:23 Calculating a Running Total
23:31 Creating a Year to Date Calculation

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