Here is the video of the training on TOP, Ranking, NTILE, and Aggregate Functions today. The first half was presented by Aaron Buma, and the second half I presented.
The following topics were covered in this session.
- RANK and DENSE_RANK
- OVER clause enhancements
- LAG and LEAD, FIRST_VALUE and LAST_VALUE
- PERCENTILE_DISC and PERCENTILE_CONT
- CUME_DIST – Cumulative Distribution
Here is the zip file to download with slides and TSQL code.