What is the OFFSET keyword in DENALI?

 Posted by Niladri.Biswas on 5/16/2013 | Category: Sql Server Interview questions | Views: 1229 | Points: 40

This keyword is use to skip the number of rows before retrieving the rows for the projection. What the statement implies is that, suppose we have 100 records and we want to skip the first 10 records. So we need the records from 11 to 100. In this case if we issue something as

Select *

From <SomeTable>
Order by <SomeColumn>
Offset 10 Rows

It will generate the expected record set.

Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response