查询各部门哪个工资等级的员工最多

select deptno, sal
  from (select deptno,
               sal,
               dense_rank() over(partition by deptno order by 出现次数 desc) as 次数排序
          from (select sal, deptno, count(*) as 出现次数
                  from emp
                 group by deptno, sal) x) y
 where 次数排序 = 1；