检索工资等级高于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))。
答案解析:有
微信扫一扫手机做题