SQLsever的子查询如何写

SQL Server中子查询可以写成以下两种形式:

1. 内嵌子查询(也称为标量子查询)：

SELECT [列名1], [列名2], ... FROM [表名] WHERE [列名] = (SELECT [列名] FROM [表名] WHERE ...);

2. 关联子查询：

SELECT [列名1], [列名2], ... FROM [表名] AS [别名] WHERE [列名] IN (SELECT [列名] FROM [表名] WHERE ...);

希望这能帮到您！