1、查出每个部门不等于经理的工资
select from emp where sal <>all(select min (sal) from emp where job='manager' group by deptno)
2
select * from emp where sal
3
select * from emp where sal>all(select min(sal) from emp where job='manager' group by deptno);
联表查询
左连接:left jion或 left outer jion 返回包括左表中所有记录和右表中联结字段相等的记录
右连接:right jion 返回包括右表中得到所有记录和左表中联结字段想等等的记录
内联接:inner jion (等值连接)只返回两个表中联结字段相等的行
举例如下:
--------------------------------------------
表A记录如下:
aID aNum
1 a20050111
2 a20050112
3 a20050113
4 a20050114
5 a20050115
表B记录如下:
bID bName
1 2006032401
2 2006032402
3 2006032403
4 2006032404
8 2006032408
------------------------