SQL Server-XML-Lesson 7-Using Row_Number(), Rank(), Dense_Rank(), and NTile()

Title: SQL Server-XML-Lesson 7-Using Row_Number(), Rank(), Dense_Rank(), and NTile()

Duration:  16 minutes

Summary: In this video, we discuss the ranking functions. We create one sql statement that covers the following: row_number(), rank(), dense_rank(), ntile(). We create the statement on the view HumanResources.vEmployeeDepartmentHistory. When we run the statement, we discuss every ranking function and how it measures against its counterparts. We see how Rank() will skip a set of values, but Dense_Rank() does not. We also see how all the ranking functions use the 'over clause'. We also tile the data using two different partitions: 5 and 10. Finally, we mention the use of synonym that simplifies typing long table and view names.

Methodology of the development of example: Good coding standard and simplified design to illustrate the key points.

Technology Used: SQL Server 2008

Keywords: table, database, primary key, synonym, row_number(), rank(), dense_rank(), ntile().