列出薪水高于所在部门平均工资的员工信息( )。
A. select deptno,ename,sal from emp a where sal>(select avg(a.sal) from emp where deptno=a.deptno);
B. select deptno,ename,sal from emp a where sal>(select avg(sal) from emp where deptno=a.deptno);
C. select a.deptno,a.ename,a.sal from emp a,emp b where a.deptno=b.deptno and a.sal>avg(b.sal);
D. select a.deptno,a.ename,a.sal from emp a,emp b where a.deptno=b.deptno and b.sal>avg(a.sal);
微信支付 
支付宝支付