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
Order by <SomeColumn>
Offset 10 Rows
It will generate the expected record set.
Asked In: Many Interviews |