Question

Grouping Sets SQL - records will all NULL values in the result

score 49 · Answer 1 · 2024-02-09T18:42:44.723000

49

Views

Grouping Sets SQL - records will all NULL values in the result

Published on 09 February 2024 at 18:42

score 35 · Answer 2 · 2024-01-26T10:51:37.733000

35

Views

ORA-56903: sys_op_pivot function is not allowed here in Oracle 19 not in 12c

Published on 26 January 2024 at 10:51

score 168 · Answer 3 · 2023-05-13T10:28:42.420000

168

Views

MariaDB: How do I sort with grouping sets / rollup?

Published on 13 May 2023 at 10:28

score 362 · Answer 4 · 2023-02-17T22:32:53.380000

362

Views

Is it possible to use grouping sets to achieve this type of aggregation using multiple joins

Published on 17 February 2023 at 22:32

score 36 · Answer 5 · 2023-01-20T18:51:54.740000

36

Views

Grouping_sets getting different output formats when group by changed

Published on 20 January 2023 at 18:51

score 51 · Answer 6 · 2022-12-08T02:56:42.203000

51

Views

Postgres grouping sets - Show count zero or named groups

Published on 08 December 2022 at 02:56

score 160 · Answer 7 · 2022-11-21T14:17:00.660000

160

Views

Why when using grouping_id with rollup the total will be level 3 instead of 2?

Published on 21 November 2022 at 14:17

score 461 · Answer 8 · 2022-10-29T15:48:28.057000

461

Views

Query using CTE and UNION ALL with Grand Total at bottom

Published on 29 October 2022 at 15:48

score 79 · Answer 9 · 2022-09-14T15:55:01.900000

79

Views

"Adding" GROUP BY's and ORDER BY's in one query instead of separate

Published on 14 September 2022 at 15:55

score 65 · Answer 10 · 2022-02-24T09:06:13.977000

65

Views

Using grouping sets in a custom function - R

Published on 24 February 2022 at 09:06

score 996 · Answer 11 · 2021-08-04T20:03:32.313000

996

Views

Postgresql - Apply a group by across multiple columns on a very large table

Published on 04 August 2021 at 20:03

score 380 · Answer 12 · 2021-07-09T07:46:38.583000

380

Views

How to make SQL query with grouping in each node of an hierarchy tree?

Published on 09 July 2021 at 07:46

score 277 · Answer 13 · 2021-06-20T16:44:15.793000

277

Views

How to distinguish between real NULL and formal NULL in Postgres ROLLUP?

Published on 20 June 2021 at 16:44

score 56 · Answer 14 · 2021-05-05T18:35:28.733000

56

Views

Using MonetDB grouping sets with Pentaho Mondrian

Published on 05 May 2021 at 18:35

score 1.3k · Answer 15 · 2021-02-11T11:54:50.367000

1.3k

Views

How to remove null values from a postgres grouping sets query

Published on 11 February 2021 at 11:54

score 165 · Answer 16 · 2021-01-04T12:42:12.087000

165

Views

Oracle - Grouping Sets and Pipelined Table Functions (expected NUMBER got ROW)

Published on 04 January 2021 at 12:42

score 1k · Answer 17 · 2020-12-02T03:37:35.390000

1k

Views

Combining OVER (PARTITION BY...) with GROUPING SETS?

Published on 02 December 2020 at 03:37

score 206 · Answer 18 · 2020-11-04T21:13:53.453000

206

Views

Optimizing query with multiple sums?

Published on 04 November 2020 at 21:13

score 928 · Answer 19 · 2020-11-04T19:47:32.863000

928

Views

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?

Published on 04 November 2020 at 19:47

score 297 · Answer 20 · 2020-10-21T04:30:54.440000

297

Views

Calculating multiple averages across different parts of the table?

Published on 21 October 2020 at 04:30

List Question

Grouping Sets SQL - records will all NULL values in the result

ORA-56903: sys_op_pivot function is not allowed here in Oracle 19 not in 12c

MariaDB: How do I sort with grouping sets / rollup?

Is it possible to use grouping sets to achieve this type of aggregation using multiple joins

Grouping_sets getting different output formats when group by changed

Postgres grouping sets - Show count zero or named groups

Why when using grouping_id with rollup the total will be level 3 instead of 2?

Query using CTE and UNION ALL with Grand Total at bottom

"Adding" GROUP BY's and ORDER BY's in one query instead of separate

Using grouping sets in a custom function - R

Postgresql - Apply a group by across multiple columns on a very large table

How to make SQL query with grouping in each node of an hierarchy tree?

How to distinguish between real NULL and formal NULL in Postgres ROLLUP?

Using MonetDB grouping sets with Pentaho Mondrian

How to remove null values from a postgres grouping sets query

Oracle - Grouping Sets and Pipelined Table Functions (expected NUMBER got ROW)

Combining OVER (PARTITION BY...) with GROUPING SETS?

Optimizing query with multiple sums?

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?

Calculating multiple averages across different parts of the table?

Trending Questions

Popular # Hahtags

Popular Questions