function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Deepu sfdcDeepu sfdc 

How to get alternate records in single SOQL query


I have 100 records i want to display records from 30 to 40 and 70 to 78 in single SOQL query ..
How it is possible ?

Thanks in advance.
SFDC Prime SquadSFDC Prime Squad
You can use offset here. For example : SELECT Name FROM Merchandise__c WHERE Price__c > 5.0 ORDER BY Name LIMIT 100 OFFSET 10
Check this out :