120 | 120 | 120 | 120 | 120 | 0 | 0 |
120 | 0 | 0 | 0 | 0 | 0 |
0 | 120 | 0 | 0 | 0 | 0 |
0 | 0 | 120 | 0 | 0 | 0 |
0 | 0 | 0 | 120 | 0 | 0 |
0 | 0 | 0 | 0 | 120 | 0 |
-- 고정값이면... WITH T1 ( COL1 , COL2 , COL3 , COL4 , COL5 ) AS ( SELECT '120' , '120' ,'120' ,'120' ,'120' ) , T2 ( num )AS ( SELECT '1' UNION ALL SELECT '2' UNION ALL SELECT '3' UNION ALL SELECT '4' UNION ALL SELECT '5' ) SELECT CASE WHEN b.num = 1 THEN COL1 ELSE NULL END COL1 , CASE WHEN b.num = 2 THEN COL2 ELSE NULL END COL2 , CASE WHEN b.num = 3 THEN COL3 ELSE NULL END COL3 , CASE WHEN b.num = 4 THEN COL4 ELSE NULL END COL4 , CASE WHEN b.num = 5 THEN COL5 ELSE NULL END COL5 FROM T1 a , T2 b