检索与30部门员工工资等级相同的员工姓名与工资。
正确答案:select * from emp e join salgrade s on (e.sal between s.LOSAL and s.HISAL) where s.grade=(select distinct s.grade from emp e join salgrade s on ((select avg(sal) from emp where deptno=30) between s.LOSAL and s.HISAL))。
答案解析:有
微信扫一扫手机做题