试题详情
简答题检索工资等级高于smith的员工信息。
  • 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 sal from emp where ename='SMITH') between s.losal and s.hisal))。

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

热门试题