SOQL HAVING

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 HAVING clause in SOQL is almost similar to WHERE except that HAVING allows you to filter using functions such as SUM, COUNT, AVG, MIN or MAX.

Example:

Find all clinics where the total booking amount in the previous month exceeds 10000 USD.

SELECT Sum(Booking_Amount__c), clinic__c
FROM Appointment__c
WHERE Appointment_time__c = LAST_MONTH
HAVING Sum(Booking_Amount__c) > 10000

Note how the WHERE clause and HAVING clause are used together in the above query.

The WHERE clause applies a filter on the rows to retrieve, and then these rows will be aggregated. The HAVING clause applies a filter on the aggregated rows returned finally.