尝试在表中查找重复值时出现 SQL 输出错误

问：

select

count([Item Nbr]) as [Item Nbr],

count([Item Flags]) as [Item Flags],

count(UPC) as UPC,

count([Store Nbr]) as [Store Nbr] ,

count (RetrievalWeek) as RetrievalWeek,

* from tblStoreItemForecast

GROUP BY

[Item Nbr],[Item Flags],UPC,

[Store Nbr], [Week 01 Forecast], [Week 02 Forecast],

[Week 03 Forecast],[Week 04 Forecast],[Week 05 Forecast],

[Week 06 Forecast],[Week 07 Forecast],[Week 08 Forecast],[Week 09 Forecast],

[Week 10 Forecast],[Week 11 Forecast],[Week 12 Forecast],[Week 13 Forecast],

[Week 14 Forecast],[Week 15 Forecast],RetrievalWeek

having (count(*) > 1)

order by RetrievalWeek desc

我收到消息错误 Msg 8120，

级别 16，状态 1，第 76 行

列“tblStoreItemForecast.Week 16 Forecast”在选择列表中无效，因为它不包含在聚合函数或 GROUP BY 子句中。

消息 209，级别 16，状态 1，第 91 行

不明确的列名称“RetrievalWeek”。

谁能帮我为什么会这样。

我尝试了另一种方法

如果我运行下面的代码，它不会给我任何结果，因为我在这里使用记录编号（唯一键）

select

[Item Nbr],[Item Flags],UPC,[Store Nbr],RetrievalWeek,recordno,COUNT(*)

from tblStoreItemForecast

GROUP BY

[Item Nbr],[Item Flags],UPC,[Store Nbr],

RetrievalWeek,recordno

having

count(*) > 1

order by RetrievalWeek desc

但是如果我在不使用记录的情况下运行以下代码，因为它在这里是唯一的 给出结果

select

[Item Nbr],[Item Flags],UPC,[Store Nbr],RetrievalWeek,COUNT(*)

from tblStoreItemForecast

GROUP BY

[Item Nbr],[Item Flags],UPC,[Store Nbr],

RetrievalWeek

having

count(*) > 1

order by RetrievalWeek desc

我想使用记录来计算重复项，没有怎么写，无法弄清楚我也使用内部连接，但是日志中的错误空间无法重用。有什么解决办法吗？