17,377
社区成员
发帖
与我相关
我的任务
分享
SELECT t.*
FROM emp t,(SELECT deptno, AVG(sal) sal FROM emp group by deptno) b
WHERE t.sal >b.sal and t.deptno=b.deptno
SELECT *
FROM emp t,(SELECT deptno, AVG(sal) sal FROM emp group by deptno) b
WHERE t.sal >b.sal and t.deptno=b.deptno ;
[Quote=引用 2 楼 zhuomingwang 的回复:]SELECT *
FROM emp t
WHERE t.sal > (SELECT AVG(b.sal) FROM emp b WHERE t.deptno = b.deptno);