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);
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);