Your database contains a table named Customer that has columns named CustomerID and Name.
You want to write a query that retrieves data from the Customer table sorted by Name listing 20 rows at a time.
You need to view rows 41 through 60.
Which Transact-SQL query should you create?
A.
Option A
B.
Option B
C.
Option C
D.
Option D
mark, offset – fetch next