题目
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);
第1题
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);
第3题
A.从员工数据库中检索销售部的平均工资
B.从员工数据库中检索销售部和其他部门的平均工资
C.从员工数据库中检索销售部和其他部门的总工资
D.从员工数据库中检索除了销售部以外其他部门的平均工资
第5题
第8题
第9题
为了保护您的账号安全,请在“赏学吧”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!