HAVING clauses

EQL provides two filtering options: WHERE and HAVING. The HAVING clause is used to filter output records.

Its syntax is as follows:

HAVING <Boolean expression>
You can use the HAVING clause with any Boolean expression, such as:

In the following example, the results include only sales representatives who generated at least $10,000:

Return Reps AS
SELECT SUM(Amount) AS SalesTotal
GROUP BY SalesRep
HAVING SalesTotal > 10000