You work as a senior developer at ABC.com. The ABC.com network consists of a single domain
named ABC.com.
You are running a training exercise for junior developers. You are currently discussing the reason
for using the OFFSET-FETCH clause of the ORDER BY Transact-SQL statement.
Which of the following describes the clause’s purpose?
A.
It allows you to only retrieve a window or page of results from the result set.
B.
It allows you to only retrieve a window from the result set.
C.
It allows you to only retrieve a page of results from the result set.
D.
It allows you to retrieve a window or page of results, as well as the entire result set.
Explanation:
http://technet.microsoft.com/en-us/library/gg699618.aspx
This one is misleading. D: can be the answer.
For example, to return the entire result,
select * from sys.objects order by name offset 0 rows
technet says: “The OFFSET-FETCH clause provides you with an option to fetch only a window or page of results from the result set.” So option A is the closest.
The reason for using OFFSET-FETCH is certainly not returning the entire set 🙂
D, as it is more accurate. It can be used to retrieve a page of result in case the total number of rows in result set is more than the page size. It will retrieve the entire result set in case the rows in result set is less than the page size.
?