List Question
20 TechQA 2024-02-09T18:42:44.723000Grouping Sets SQL - records will all NULL values in the result
49 views
Asked by Jhansi
ORA-56903: sys_op_pivot function is not allowed here in Oracle 19 not in 12c
35 views
Asked by Željko Matić
MariaDB: How do I sort with grouping sets / rollup?
168 views
Asked by Manngo
Is it possible to use grouping sets to achieve this type of aggregation using multiple joins
362 views
Asked by zapf2023
Grouping_sets getting different output formats when group by changed
36 views
Asked by Beefstu
Postgres grouping sets - Show count zero or named groups
51 views
Asked by chishiki
Why when using grouping_id with rollup the total will be level 3 instead of 2?
160 views
Asked by Gal Mor
Query using CTE and UNION ALL with Grand Total at bottom
461 views
Asked by AllSolutions
"Adding" GROUP BY's and ORDER BY's in one query instead of separate
79 views
Asked by pileup
Using grouping sets in a custom function - R
65 views
Asked by fe108
Postgresql - Apply a group by across multiple columns on a very large table
996 views
Asked by ricardomart
How to make SQL query with grouping in each node of an hierarchy tree?
380 views
Asked by diziaq
How to distinguish between real NULL and formal NULL in Postgres ROLLUP?
277 views
Asked by diziaq
Using MonetDB grouping sets with Pentaho Mondrian
56 views
Asked by Llorieb
How to remove null values from a postgres grouping sets query
1.3k views
Asked by Akshar Vibhav
Oracle - Grouping Sets and Pipelined Table Functions (expected NUMBER got ROW)
165 views
Asked by ravioli
Combining OVER (PARTITION BY...) with GROUPING SETS?
1k views
Asked by alhazen
Optimizing query with multiple sums?
206 views
Asked by alhazen
A column in a Grouping Set is NULL when it shouldn't be = SQL Server bug, or more likely, do I not understand Grouping Sets?
928 views
Asked by schaneville
Calculating multiple averages across different parts of the table?
297 views
Asked by alhazen