Filter
Top Products
[Figure: Example of grouping tables by using parts of character strings]
Case-splitting data and grouping tables
Specify a CASE expression in the GROUP BY clause to split column data into cases instead of columns, and to group
tables for each value split into cases. An example of specification is shown below. For details on the CASE expression,
refer to "6.7 Using Case Expression to Manipulate Data."
Example 5
The retail-sale history table is grouped for each generation, and the total proceeds are fetched for each
generation.
76