[SQL] PIVOT 과 UNPIVOT

PIVOT

SELECT 
	m1, m2, m3, m4
FROM
(
	SELECT 'm1' col, 10 val UNION ALL
	SELECT 'm2' col, 20 val UNION ALL
	SELECT 'm3' col, 30 val UNION ALL
	SELECT 'm4' col, 40 val
) a
PIVOT
(
	SUM(val) FOR col IN (m1, m2, m3, m4)
) b

결과

m1	m2	m3	m4
10	20	30	40

 

 

UNPIVOT 

SELECT 
	col, val 
FROM 
(
	SELECT 10 AS m1, 20 AS m2, 30 AS m3, 40 AS m4 
) a
UNPIVOT
(
	val FOR col in (m1, m2, m3, m4)
) b

결과

col	val
m1	10
m2	20
m3	30
m4	40