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