Understanding ROW NUMBER And RANK And The Other Ranking Functions

Duration:  9 Minutes 08 Seconds (7.22 MB)

This SQL Tutorial will introduce the Ranking functions that are a new category of functions introduced with SQL Server 2005. The SQL Server 2005 Ranking Functions allow you to rank the records returned in your result sets, and more. You will see several examples on how they can be used.

• Introduction to SQL Server 2005 Ranking Functions


• Learn how to use ROW NUMBER and RANK


• Learn how to use DENSE_RANK and NTILE

Other SQL Tutorials that you might be interested in:

Duration:  11 Minutes 31 Seconds (9.81 MB)

Duration:  10 Minutes 49 Seconds (9.85 MB)