GROUP-BY 表达式必须至少包含一列不是外部引用

2021-09-10 00:00:00 tsql sql-server-2008 sql-server

我有这个查询:

SELECT
SolutionName    -- Solution_NAM
from  Table_View
Group By 1

其中 Table_View 当然是一个视图.我收到此错误消息:

where Table_View is of course a view. I am gettign this error message:

每个 GROUP BY 表达式必须包含至少一列不是外部引用.

Each GROUP BY expression must contain at least one column that is not an outer reference.

你能帮我解决这个问题吗?它在 Ms SQL Server 2008 中

Can you help me resolve this? It´s inside Ms SQL Server 2008

推荐答案

你不能给 Group by 1

you cannot give Group by 1

试试

SELECT
SolutionName    -- Solution_NAM
from  Table_View
Group By SolutionName

相关文章