SQL Server迁移 [英] SQL SERVER MIGRATION

问题描述

大家好，
我在选择查询中使用了group by子句

对于例如

从empa中选择a.empname，a.phone，@ designation，其中
a.joiningdate =''2010-11-04''
按部门分组

对于以上查询，发生以下提到的错误.

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




谢谢和问候，
MUGAMATHISMAIL K

Hi all,
I am using a group by clause in a select query

For eg

select a.empname,a.phone,@designation from empdetails a where
a.joiningdate = ''2010-11-04''
group by a.dept

For the above query, the below mentioned error occurs.

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




Thanks and Regards,
MUGAMATHISMAIL K

推荐答案

mugamnath，

将查询更改为类似以下内容:

Hi mugamnath,

Change your query to somehting like this:

select a.empname,a.phone,@designation from empdetails a where
a.joiningdate = ''2010-11-04''
group by a.dept, a.empname, a.phone, @designation

这篇关于SQL Server迁移的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！