SOQL LIMIT

SOQL Tutorial What is SOQL SOQL Real Life Scenario SOQL Naming Conventions SOQL WHERE SOQL Comparison Operators SOQL Logical Operators SOQL ORDER BY SOQL LIMIT SOQL OFFSET SOQL Aggregate Functions SOQL GROUP BY SOQL HAVING SOQL Relationship Queries SOQL Date Literals SOQL Date Functions SOQL History Objects SOQL Sharing Objects SOQL in APEX Apex Variables in SOQL Queries Static and Dynamic SOQL SOQL return types SOQL Governor Limits Efficient SOQL Queries

The LIMIT clause is used to limit the number of rows returned by a SOQL query. The maximum number of records that should be fetched is specified in the Limit clause. The LIMIT clause is optional, but it is highly recommended to use

Example #1: Find the first 50 clinics in Florida ordered by their name.

SELECT Id, Name
FROM Clinic__c
ORDER BY Name
LIMIT 50

You can also apply a limit on SOQL queries containing group by clause. In that case only the first few rows of aggregated records are returned.

Example #2: Find the top 10 clinics with maximum revenue from booking amount.

SELECT Sum(Booking_Amount__c), clinic__c
FROM Appointment__c
GROUP BY Clinic__c
ORDER BY Sum(Booking_Amount__c) DESC
LIMIT 10