SQL Server 中的嵌套选择语句

Nested select statement in SQL Server(SQL Server 中的嵌套选择语句)

问题描述

为什么下面的方法不起作用?

Why doesn't the following work?

SELECT name FROM (SELECT name FROM agentinformation)

我想我对 SQL 的理解是错误的，因为我原以为这会返回与

I guess my understanding of SQL is wrong, because I would have thought this would return the same thing as

SELECT name FROM agentinformation

内部的 select 语句不是创建一个结果集，然后外部的 SELECT 语句会查询吗?

Doesn't the inner select statement create a result set which the outer SELECT statement then queries?

推荐答案

您需要为子查询添加别名.

You need to alias the subquery.

SELECT name FROM (SELECT name FROM agentinformation) a  

或者更明确

SELECT a.name FROM (SELECT name FROM agentinformation) a  

这篇关于SQL Server 中的嵌套选择语句的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持编程学习网！