Oracle习题

1.查询各种工作的最低工资

select job,min(sal),count(ename) from emp group by job;

2.查询所有员工工资都大于1000的部门的信息及员工信息

select d.dname, e.* from emp e,dept d where e.deptno=d.deptno and not e.deptno in(select deptno from emp where sal<1000);