SPServices CAMLQuery Skip some rows

Question

I want to Skip some records and get other records in SPServices CAML Query

for example my List has got 100 records, I want to skip first 20 records and get 10 records.

how do I do it in SPServices, I want to implement paging in my List using SPServices.

Answer 1

SharePoint does not work like SQL so you do not have Limit and Offset values like you have in SQL.

To do it using SPServices you can follow this link Paging using SPServices

You can also do pagination without using SPServices which uses PageSize and PagePosition to track items

Paging With Sharepoint