SELECT *
  FROM emp t
 WHERE t.sal > (SELECT AVG(b.sal) FROM emp b WHERE t.deptno = b.deptno);

------解决方案--------------------
探讨

SQL code
SELECT *
  FROM emp t
 WHERE t.sal > (SELECT AVG(b.sal) FROM emp b WHERE t.deptno = b.deptno);


------解决方案--------------------
哈哈,莫笑我,这样其实效率没用表关联高.
SQL code

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 ;

------解决方案--------------------
楼上的正解
不过也可以这么写
select * from scott.emp t1
where t1.sal > (select sal from
(select deptno,avg(sal) sal from scott.emp group by deptno) t2 where t1.deptno = t2.deptno);


------解决方案--------------------
SQL code
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

------解决方案--------------------
探讨

在oracle自带用户soctt下emp表中：找出所有的雇员，他们挣的薪水高于该部门的平均薪水？？？这里要注意有个该字！
请帮忙，尽快，3KU!


------解决方案--------------------
都是强人