快捷搜索:

SQL Server数据库技术(61)

在一个SELECT 语句的WHERE 子句或HAVING 子句中嵌套另一个SELECT 语句的查询称为嵌套查询,又称子查询。子查询是SQL 语句的扩展,其语句形式如下:

SELECT [,...]

FROM

WHERE [表达式] (SELECT [,...]

FROM

[GROUP BY

HAVING [对照运算符] (SELECT [,...]

FROM)]

您可能还会对下面的文章感兴趣: