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
|
SELECT * FROM
(SELECT * FROM Produce)
PIVOT(SUM(sales) FOR quarter IN ('Q1', 'Q2', 'Q3', 'Q4'));
SELECT * FROM
(SELECT sales, quarter FROM Produce)
PIVOT(SUM(sales) FOR quarter IN ('Q1', 'Q2', 'Q3', 'Q4'));
SELECT * FROM
(SELECT * FROM Produce)
PIVOT(SUM(sales) FOR quarter IN ('Q1', 'Q2', 'Q3'));
SELECT * FROM
(SELECT sales, quarter FROM Produce)
PIVOT(SUM(sales) FOR quarter IN ('Q1', 'Q2', 'Q3'));
SELECT * FROM
(SELECT sales, quarter FROM Produce)
PIVOT(SUM(sales), COUNT(sales) FOR quarter IN ('Q1', 'Q2', 'Q3'));
SELECT
col1,
col2
FROM
table1
PIVOT(SUM(`grand_total`) FOR REPLACE(LOWER(`media_type`), " ", "_") IN (
"cinema", "digital", "direct_mail", "door_drops", "outdoor", "press", "radio", "tv"
));
SELECT
col1,
col2
FROM
table1
PIVOT(SUM(`grand_total`) FOR `media_type` IN (
"cinema", "digital", "direct_mail", "door_drops", "outdoor", "press", "radio", "tv"
));
SELECT
col1,
col2
FROM
table1
PIVOT(SUM(`grand_total`) FOR '2' || '1' IN (
"cinema", "digital", "direct_mail", "door_drops", "outdoor", "press", "radio", "tv"
));
|
