多做题,通过考试没问题!

Oracle

睦霖题库>大学试题(计算机科学)>Oracle

检索工资等级高于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))。
答案解析:
进入题库查看解析

微信扫一扫手机做题