Transact-SQL (T-SQL) introduces multiple ranking functions to return a ranking value for each row in a partition result-set. This lab is divided into six exercises explaining different types of ranking functions such as ROW_NUMBER, RANK, DENSE_RANK and NTILE functions.
Exercise 1: ROW_NUMBER Function
Exercise 2: RANK Function
Exercise 3: DENSE_RANK Function
Exercise 4: NTILE Function
Exercise 5: Self-Assessment
Exercise 6: T-SQL Challenge