SQL语句总结4之子查询

将一个查询的结果,做为另外一个查询的参数,即是子查询

[b]1.在子查询中使用聚合函数[/b]
在老师表中查询所有高于平均年龄的老师

SELECT * FROM teacher
WHERE age > 
(SELECT  AVG(age) from teacher)

[b]2.IN子查询[/b]

SELECT * FROM student
WHERE CNO=10
AND SNO IN (SELECT SNO FROM STUDENT WHERE CNO = 11)

[b]3.EXISTS子查询[/b]
基本语法如下:

SELECT column_name
FROM   table_name
WHERE  [NOT] EXISTS (subquery)

[b]4.SOME/ALL子查询[/b]
待研究

[b]5.UNIQUE子查询[/b]
待研究