① 以多少行作為一組進行處理 oracle
試試這樣select trunc((rownum - 1) / 5), count(*) from (select * from tmp_xd_test order by id) a group by trunc((rownum - 1) / 5);