C1 | C2 |
---|---|
1 | A |
1 | B |
1 | C |
||
V
C1 | C2 | C3 | C4 |
---|---|---|---|
1 | A | B | C |
SELECT c1,
MAX(CASE c2 WHEN ‘A’ THEN ‘A’ END) AS c2,
MAX(CASE c2 WHEN ‘B’ THEN ‘B’ END) AS c3,
MAX(CASE c2 WHEN ‘C’ THEN ‘C’ END) AS c4
FROM t1
C1 | C2 |
---|---|
1 | A |
1 | B |
1 | C |
||
V
C1 | C2 | C3 | C4 |
---|---|---|---|
1 | A | B | C |
SELECT c1,
MAX(CASE c2 WHEN ‘A’ THEN ‘A’ END) AS c2,
MAX(CASE c2 WHEN ‘B’ THEN ‘B’ END) AS c3,
MAX(CASE c2 WHEN ‘C’ THEN ‘C’ END) AS c4
FROM t1