[펌] 한줄을 두줄로

백과사전 | 소토로
http://blog.naver.com/ssari93/120006907670

SELECT  CODE_FIRST
     ,  CODE_HNAME
  FROM  TFBSOPE
 WHERE  CODE_FIRST LIKE 'B03%'
   AND  CODE_USEYN    = 'Y'
 ORDER  BY CODE_HNAME

 

두줄로 나오기(출력방향은 왼쪽에서 오른쪽으로)
1 2
3 4
5

SELECT  CODE_FIRST
     ,  CODE_HNAME
     ,  CODE_FIRST2
     ,  CODE_HNAME2
  FROM  (SELECT  ROWNUM AS RNUM
              ,  CODE_FIRST
              ,  CODE_HNAME
              ,  CODE_FIRST2
              ,  CODE_HNAME2
           FROM  (SELECT  CODE_FIRST
                       ,  CODE_HNAME
                       ,  LEAD (CODE_FIRST) OVER (ORDER BY CODE_HNAME)
                          AS CODE_FIRST2
                       ,  LEAD (CODE_HNAME) OVER (ORDER BY CODE_HNAME)
                          AS CODE_HNAME2
                    FROM  TFBSOPE
                   WHERE  CODE_FIRST LIKE 'B03%'
                     AND  CODE_USEYN    = 'Y'))
 WHERE  MOD(RNUM, 2) = 1

 

 

두줄로 나오기(출력방향은 위에서 아래로)

1 4
2 5

3

SELECT  CODE_FIRST
     ,  CODE_HNAME
     ,  CODE_FIRST2
     ,  CODE_HNAME2
  FROM  (SELECT  CODE_FIRST
              ,  CODE_HNAME
              ,  LEAD (CODE_FIRST, CEIL(CNT / 2)) OVER (ORDER BY CODE_HNAME)
                 AS CODE_FIRST2
              ,  LEAD (CODE_HNAME, CEIL(CNT / 2)) OVER (ORDER BY CODE_HNAME)
                 AS CODE_HNAME2
              ,  RNUM
              ,  CNT
           FROM  (SELECT  CODE_FIRST
                       ,  CODE_HNAME
                       ,  ROWNUM AS RNUM
                       ,  COUNT(*) OVER () AS CNT
                    FROM  (SELECT  CODE_FIRST
                                ,  CODE_HNAME
                             FROM  TFBSOPE
                            WHERE  CODE_FIRST LIKE 'B03%'
                              AND  CODE_USEYN    = 'Y'
                            ORDER  BY CODE_HNAME)))
 WHERE  RNUM <= CEIL(CNT / 2)