1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
|
select foo, count(*) from bar group by all;
select
letter,
sum(num) as sum_num
from
table_test
group by grouping sets (1, ());
select
letter,
sum(num) as sum_num
from
table_test
group by grouping sets (letter, ());
select
product_type,
product_name,
sum(product_count) as product_sum
from products
group by
grouping sets (
product_type,
rollup(product_type, product_name)
)
order by product_type, product_name;
select
product_type,
product_name,
sum(product_count) as product_sum
from products
group by
grouping sets (
product_type,
cube(product_type, product_name)
)
order by product_type, product_name;
select
product_type,
product_name,
sum(product_count) as product_sum
from products
group by rollup (product_type, product_name)
order by product_type, product_name;
select
product_type,
product_name,
sum(product_count) as product_sum
from products
group by cube (product_type, product_name)
order by product_type, product_name;
|
