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
I think it’s B
I don’t see the picture coz it’s broken, but I guess it should look like:
select CustomerID, Name
from Customers
order by Name
offset 40 rows fetch next 20 rows only;
*’next’ is eq to ‘first’ but in this context ‘next’ matches better.
I checked, the correct answer is B