How can we control pagination by offset in Salesforce?

For example, you have a SOQL query that returns 1000 rows and you want it see only 100, you would add “OFFSET 900″ at the end of the SOQL query: SELECT Name FROM Object__c ORDER BY Name OFFSET 900 ; This feature is particularly handy in pagination (using the Limit function to break large amount of data into pages).