anydragon

mac, linux, aws, c, c++, mysql, mssql, redis, csharp, nodejs, rust, golang

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

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]

)