TOP, Ranking, NTILE, and Aggregate Functions

Download PDF

 

Continuing our weekly SQL Query Training for the 70-461 exam preparation, at Steve Stedman, sharing this weeks class with the world. Free SQL Query training.

TOPRankingNTILEandAggregateFunctions

 

 

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.

  • —TOP(N)
  • —RANK and DENSE_RANK
  • —ROW_NUMBER
  • —NTILE
  • —OVER clause enhancements
  • —LAG and LEAD,  FIRST_VALUE and LAST_VALUE
  • —PERCENT_RANK
  • —PERCENTILE_DISC and PERCENTILE_CONT
  • —CUME_DIST – Cumulative Distribution

Here is the zip file to download with slides and TSQL code.
TopRankingNtileAndAnalytics.zip.

 

See Also

Tagged with: , , ,

Leave a Reply

Your email address will not be published. Required fields are marked *

*

Time limit is exhausted. Please reload CAPTCHA.