TOP, Ranking, NTILE, and Aggregate Functions

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.

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

• ROWS PRECEDING and FOLLOWING
• ROWS UNBOUNDED
• LAG and LEAD
• —PERCENT_RANK
• —PERCENTILE_DISC and PERCENTILE_CONT
• SQL Queries Training for SQL 70-461 certification.
• Last Weeks Training on Aggregation and Aggregation Strategies.

More from Stedman Solutions:

Steve and the team at Stedman Solutions are here for all your SQL Server needs.
Contact us today for your free 30 minute consultation..
We are ready to help!