Which Transact-SQL query should you create?

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?

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



Leave a Reply 1

Your email address will not be published. Required fields are marked *


lewis

lewis

mark, offset – fetch next