Filter
Top Products
[Figure: Example of a table derived from a HAVING clause]
HAVING clause
Specify the search conditions for the groups to be processed in the HAVING clause. The columns used as conditions
must either be grouped columns or must be able to be specified by a set function. If a column other than a grouped
column is specified by other than a set function, an error occurs.
The WHERE clause can also specify search conditions for grouped columns. Whereas the HAVING clause targets
grouped tables, the WHERE clause specifies the rows to be processed in the step before being grouped. Therefore,
80