① 以多少行作为一组进行处理 oracle
试试这样select trunc((rownum - 1) / 5), count(*) from (select * from tmp_xd_test order by id) a group by trunc((rownum - 1) / 5);