4 ms·
I'm not familiar with those statements, can you provide an example?
by paulsmith 11y ago
I'm not familiar with those statements, can you provide an example?
- jsmeaton 11y agoThey're useful for providing summaries like row totals and column totals. Rather than just get an aggregated count for the total GROUP, you can also get aggregated counts for each unique combination of columns within the GROUP. col1 col2 count ---- ---- ----- a b 10 a null 5 null b 5 There's more to it than that obviously, but you can read about them here: http://www.postgresql.org/docs/devel/static/queries-table-expressions.html http://www.postgresql.org/docs/devel/static/queries-table-ex... (7.2.4. GROUPING SETS, CUBE, and ROLLUP)