StackOverflow Questions for Tag: grouping-sets

Jhansi
Jhansi

Reputation: 25

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

Score: 0

Views: 181

Answers: 0

Read More
Manngo
Manngo

Reputation: 16281

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

Score: 1

Views: 412

Answers: 0

Read More
zapf2023
zapf2023

Reputation: 19

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

Score: 0

Views: 501

Answers: 2

Read More
Beefstu
Beefstu

Reputation: 857

Grouping_sets getting different output formats when group by changed

Score: 0

Views: 35

Answers: 1

Read More
chishiki
chishiki

Reputation: 702

Postgres grouping sets - Show count zero or named groups

Score: 0

Views: 61

Answers: 0

Read More
Gal Mor
Gal Mor

Reputation: 1

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

Score: 0

Views: 258

Answers: 1

Read More
AllSolutions
AllSolutions

Reputation: 1266

Query using CTE and UNION ALL with Grand Total at bottom

Score: 2

Views: 679

Answers: 2

Read More
pileup
pileup

Reputation: 3262

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

Score: 2

Views: 86

Answers: 2

Read More
fe108
fe108

Reputation: 501

Using grouping sets in a custom function - R

Score: 1

Views: 67

Answers: 1

Read More
user16595403
user16595403

Reputation:

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

Score: 0

Views: 1096

Answers: 1

Read More
diziaq
diziaq

Reputation: 7785

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

Score: 0

Views: 447

Answers: 2

Read More
diziaq
diziaq

Reputation: 7785

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

Score: 0

Views: 370

Answers: 1

Read More
Llorieb
Llorieb

Reputation: 35

Using MonetDB grouping sets with Pentaho Mondrian

Score: 0

Views: 58

Answers: 0

Read More
Akshar Vibhav
Akshar Vibhav

Reputation: 53

How to remove null values from a postgres grouping sets query

Score: 3

Views: 1479

Answers: 1

Read More
ravioli
ravioli

Reputation: 3823

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

Score: 2

Views: 187

Answers: 2

Read More
alhazen
alhazen

Reputation: 1915

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

Score: 1

Views: 1389

Answers: 1

Read More
alhazen
alhazen

Reputation: 1915

Optimizing query with multiple sums?

Score: 1

Views: 225

Answers: 1

Read More
schaneville
schaneville

Reputation: 23

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?

Score: 1

Views: 1067

Answers: 1

Read More
green_C
green_C

Reputation: 69

How to reshape data after GROUPING SETS in Hive?

Score: 2

Views: 3329

Answers: 1

Read More
alhazen
alhazen

Reputation: 1915

Calculating multiple averages across different parts of the table?

Score: 0

Views: 340

Answers: 1

Read More
PreviousPage 1Next