Development questions
What is the difference between LIMIT and OFFSET in SOQL, and what is the maximum value of OFFSET (2,000)?
LIMIT n caps the number of rows returned. OFFSET n skips the first n rows, useful for pagination (LIMIT 20 OFFSET 40 = page 3).
The maximum OFFSET is 2,000. For deeper pagination use keyset pagination (WHERE Id > :lastId ORDER BY Id LIMIT 200) or queryMore / Database.getQueryLocator.
soql
SELECT Id, Name FROM Account ORDER BY Name LIMIT 10 OFFSET 20
soqlpaginationlimits
More Development questions
- What is an Apex Trigger in Salesforce and when should you use it over Flows?
- What is the difference between before triggers and after triggers?
- Explain all Trigger context variables (isInsert, isUpdate, isDelete, isUndelete, isBefore, isAfter, isExecuting, size, operationType).
- What is the difference between Trigger.new and Trigger.old?
- In which trigger events are Trigger.new and Trigger.newMap available?
- In which trigger events are Trigger.old and Trigger.oldMap available?