Filter
Top Products
[Figure: Case-splitting data and grouping tables]
Grouping tables by month
To group tables of a DATE-type column by year or month, specify the date-time value function. A specification
example is shown below. For details on the date-time value function, see "6.5 Manipulating Date Data."
Example 6
The sales dates in the RETAILSALESHIST table are grouped by month, and the total proceeds are
fetched.
77