This lab talks about a very common yet difficult problem, finding TOP n rows per group. The problem may seem easy, however in this lab we’ll discuss multiple ways to solve this problem and compare the different ways on performance to find out the fastest way to solve the problem. In the first exercise, we’ll talk about TOP use cases and in the second exercise we’ll talk about the Top n rows per group problem and it’s different solutions.

Subscribe to Download


Version1.0
Download1
File Size951.09 KB
Create DateMarch 30, 2017
Last UpdatedMarch 30, 2017
New Security Features in SQL Server 2016
Delete vs Truncate in SQL Server