HAVING句は、出力レコードをフィルタリングするときに使用します。
HAVING <BooleanExpression>
Return Reps AS SELECT SUM(Amount) AS SalesTotal GROUP BY SalesRep HAVING SalesTotal > 10000
// Invalid because Price is not defined in the statement (i.e., Price is a corpus attribute). Return results AS SELECT SUM(Price) AS TotalPrices GROUP BY WineType HAVING Price > 100 // Valid because TotalPrices is defined in the statement. Return results AS SELECT SUM(Price) AS TotalPrices GROUP BY WineType HAVING TotalPrices > 100