Here is another popular lab from Hands-On-Lab library: TOP and APPLY Operators in SQL Server.
In Transact-SQL (T-SQL) TOP allows us to limit the number of rows from the query result-set. The APPLY operator allows us to invoke a table-valued functions for each row returned by the outer table expression of a query. This lab is divided into seven exercises explaining differnet scenarios where TOP & APPLY operators are handy such as data modification and filtering the data.
Exercise 1: TOP filter
Exercise 2: TOP WITH TIES
Exercise 3: TOP for data modification
Exercise 4: OFFSET-FETCH FILTER
Exercise 5: APPLY operator
Exercise 6: Self-Assessment
Exercise 7: 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.