[Function] NTILE

範例 : 

select NTILE(2) over (order by rownum) from dual 

connect by rownum <= 10

結果 : 

1

1

1

1

1

2

2

2

2

2