More specifically, I want to create various individual SELECT queries in which I retrieve the first 1000 results of the object, than the next 1000 and so on. Example:
SELECT Id, Name FROM Account WHERE rowIndex BETWEEN 1 AND 1000;
SELECT Id, Name FROM Account WHERE rowIndex BETWEEN 1001 AND 2000;
(...)
The thing is, the column "rowIndex" (or an equivelent one) does not exist in the object (column "Id" does not qualify).
I know OFFSET could be an option but it's limited to 2000 records and I have around 100000.
So, how can I retrieve only 1000 results each time of the query: "SELECT Id, Name FROM Account"?
Thank you.