날자별

2009 9월
 123456
78910111213
14151617181920
21222324252627
282930  

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

출처 : 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]