OracleSQL

select * from emp where sal in(select min(sal) from emp group by deptno)//查询每个部门中最低工资的员工信息


//查询出：部门名称、部门员工数、部门的平均工资、部门的最低收入雇主的姓名：程序要关联两张表 dept/emp
select d.deptname,ed.c,ed,a from dept d,(select deptno,count(empno) c,avg(sal) a from emp group by deptno) ed where d.deptno=ed.deptno
 
create table aa as select * from emp//表复制  如果不需要数据，只需要写一个永远不可能成立的条件即可


delete from emp where empname is  not null//删除部门名称不为空的员工信息



select  c1.courcename c11,c2.courcename c22 from cource c1,cource c2 where c1.courcename <>c2.courcename order by c1.courcename desc//自己关联自己，产生矩阵




oracle中分页  如果查询5-10之间的记录/只能利用子查询，不能利用between and

select * from (select rownum rm,empno,empname from emp where rownum<=10) temp where temp.rm>5