我们oracle老师留了一些作业,然后百度不到,所以我来给学弟学妹们提供个方便,我真棒~
在scott用户的emp表下
1.查询工资最高的雇员名字和工资
select ename,sal from emp where sal=(select max(sal) from emp);
2.查询工资比SCOTT高或者雇佣时间比SCOTT早的雇员的编号和名字
select empno,ename
from emp
where sal>(select sal from emp where ename = 'SCOTT') or
hiredate>(select hiredate from emp where ename = 'SCOTT');
update emp set job = 'manager',sal = 4000 where ename = 'SCOTT';