select * from(
select DISTRICT_CODE,ROWNUM rn
from
(select DISTRICT_CODE,count(1) a
from T_TRAFFIC_JEEVES
group by DISTRICT_CODE
order by a desc )
where ROWNUM <= 5
) where rn >= 1
oracle分页并排序
最新推荐文章于 2025-02-18 15:20:32 发布