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