어느용

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

[sql]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] )[/sql]