데이터 그룹으로 나누기(NTILE)

by 지기 · 2014-02-06

SELECT NTILE (3) OVER (ORDER BY RN) GROUP_NO
  , RN DATA
  FROM (SELECT LEVEL RN FROM DUAL CONNECT BY LEVEL < 11);