玖叶教程网

oracle——汇总后排序取前10名

方法一

select rownum rn,a.*
from 
(
  select ADMISSION_DEPT_NAME,sum(total_amount) total_amount
  from FJ_DJ
  group by ADMISSION_DEPT_NAME
  order by total_amount desc
) a
where rownum<=10

方法二

select * from 
(
    select row_number() over(order by mm desc) rn,a.*
    from 
    (
      select ADMISSION_DEPT_NAME,sum(total_amount) mm
      from FJ_DJ
      group by ADMISSION_DEPT_NAME
      order by sum(total_amount) desc
    ) a
) b
where rn<=10

2022-12-6