SQL语句scott数据库查询平均薪水等级最高的部门名称怎么写?

2025-03-23 17:27:33
推荐回答(1个)
回答1:

SELECT * FROM dept WHERE deptno=(
SELECT deptno
FROM (SELECT deptno FROM emp GROUP BY deptno ORDER BY AVG(sal) DESC)
WHERE ROWNUM=1);