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-top/

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!

Learn how to select the top rows from an Excel table an SQL query. You'll learn how to select a specific number of rows from the top of a list and how to use the Order By clause to influence which rows appear at the top. You'll see how to deal with tied rows by including a tie-breaker field and how to select a percentage of the rows from a table.

Chapters
00:00 Topic List
00:37 The Basic Setup
02:37 Selecting a Specific Number of Rows
03:47 Asking for More than the Available Rows
04:23 Combining Top N with the Order By Clause
05:11 Changing the Sort Order
05:56 Returning Tied Results
07:21 Sorting by a Tie-Breaker Field
08:42 Using Unique Identifiers as Tie-Breakers
09:32 Returning a Percentage of Rows
10:22 Percentage of Rows and Tied Results
12:36 Rounding Up Rows Returned with Top N Percent
14:44 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