17,082
社区成员
发帖
与我相关
我的任务
分享
select avg_sal,deptno
from(select deptno,avg_sal,row_number()over(order by avg_sal) as rn
from(select deptno,avg(sal)over(partition by deptno) avg_sal from emp)
)
where rn = 1
SELECT TOP 1 deptno FROM (
SELECT deptno,AVG(sal) AS avg_sal,
FROM emp
GROUP BY deptno
) a
ORDER BY avg_sal DESC