Select e.empno,e.ename,m.empno,m.enmae
From
Emp emp e,emo m
where
e.mgr=m.empno;
1.自连表查询 行变列
select empno,ename from emp;
select rownum,empno,ename from emp;
2.rownum:伪列
select rownum,empno,ename from emp where rownum<=5; ##true
select rownum,empno,ename from emp where rownum<=5 ##fault
3.分页:1-5
select * from(
select rownum r,empno,ename from emp
where rownum<=5
)t
where t.r>0;
分页:6-10
select * from(
select rownum r,empno,ename from emp
where rownum<=10
)t
where t.r>5;
4.使用 max/min 查询最高工资
select max(sal) from emp;
select min(sal) from emp;
5.使用 avg 查询平均工资
select avg(sal) from emp;