Ok, now I think I got it.
GROUP BY () groups all the rows into one group (although logically they
were one group already)
but this is needed if one wants to use aggregate operators in the
restriction of rows.
And now that all the rows are in a group we can use the having clause to
filter that group.
Thank you for clarifications, Lukas.
Cube, rollup and grouping sets do not seem to me very useful shorthands.
Do you have examples of why they would be useful?
- Rami
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.
