Filter
Top Products
[Figure: Example of grouping tables by month]
6.1.2 Specifying groups to be processed from a grouped table
The WHERE clause can be used in a table expression to specify rows to be processed in the table specified in the
FROM clause. To do this, specifying the groups to be processed in a table grouped by the GROUP BY clause, using a
HAVING clause. The following is an example of specifying the HAVING clause:
Example:
In this example, the totals of ITMNO and STOCKQTY are obtained for products with two or more
occurrences of the same ITMNO from the grouped table in Figure: Example of a table derived from
GROUP BY clause shows the table derived from the GROUP BY clause.
78