Here is another popular lab from Hands-On-Lab library: SQL Server Ranking Functions.
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
SQLMaestros Hands-On-Labs enables the practical way of learning. Each lab document consists of multiple exercises and each exercise consists of multiple tasks. Apart from step-by-step instructions, the HOL document contains images, explanations, observations, notes, tips & tricks to ensure a great learning experience. With each lab, you can practice a specific concept step-by-step. With our HOL documents, you will get hands-on with hundreds of topics in SQL Server & Microsoft Data Platform. Learn More.