In Transact-SQL (T-SQL) 2012 OFFSET-FETCH clause provides us an option to fetch page of results from the result set. This lab is divided into six exercises explaining different usages of OFFSET-FETCH clause such as skip few rows from the result set, fetch a specific row, and fetch few rows from the result set and implementing paging using OFFSET-FETCH.
Exercise 1: Skip few rows from the result set
Exercise 2: Fetch a specific row
Exercise 3: Fetch few rows from the result-set
Exercise 4: Implement paging using OFFSET-FETCH
Exercise 5: Self-Assessment
Exercise 6: T-SQL Challenge