What is the OFFSET keyword in DENALI?

Answer:

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.