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

File Size951.09 KB
Create DateMarch 30, 2017
Last UpdatedMarch 30, 2017