sql Archives - 3 중 3 번째 페이지

select 시에 세로행 출력을 가로행 출력으로 변환

출처 : http://bomb.egloos.com/1073673

SELECT
	MAX(DECODE(A, '1', B) as COL1,
	MAX(DECODE(A, '2', B) as COL2,
	MAX(DECODE(A, '3', B) as COL3
FROM
(
	SELECT A, B FROM [table]
)

SELECT

MAX(DECODE(A, '1', B) as COL1,

MAX(DECODE(A, '2', B) as COL2,

MAX(DECODE(A, '3', B) as COL3

FROM

(

SELECT A, B FROM [table]

)