oracle统计百分比

select oi_pid ,count(oi_pid) as order_count,

    round(count(oi_pid)/(select count(*) from JDOrderItem)*100,2)||'%' as percent
from JDOrderItem 

group by oi_pid

分页：

SELECT * FROM 
(
SELECT A.*, ROWNUM RN 
FROM (SELECT * FROM TABLE_NAME) A 
WHERE ROWNUM <= 40
)
WHERE RN >= 21