试题详情
简答题检索与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))。

  • 关注下方微信公众号，在线模考后查看

热门试题