How can we implement pagination in Visualforce?

Hi Manpreet

In spring 12, Salesforce has come up with ability of SOQL to get records from position “X” instead of position “1” every time to help creating pagination feature.

Select Id, Name from Lead LIMIT 5 OFFSET 2

Above query will return 5 Lead records starting from record number 10 (5×2).

You can get more information by going through this link:https://developer.salesforce.com/blogs/developer-relations/2012/01/soql-offset-in-spring-12.html

Hope it helps