2015-10-28 11:26 GMT+01:00 Rami Ojares <rami.oja...@gmail.com>: > 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. >
Yes > 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? Why not? How else would you aggregate revenue over several dimensions? - Total revenue, revenue per business unit, revenue per sales employee: ROLLUP - Total revenue, revenue per business unit, revenue per country, revenue per country and business unit: CUBE The same can be achieved with lots of UNION ALL repetition, as explained in that SQL Server page. Cheers Lukas -- 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 h2-database+unsubscr...@googlegroups.com. To post to this group, send email to h2-database@googlegroups.com. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
