大家快来看看啊，这句Sql的错误!

来源：百度知道 编辑：UC知道 时间：2024/05/24 11:57:59
SELECT ItemFlag, Unit, UnitPrice, SUM(CONVERT(float, ProduceQuantity)) AS ProCount
FROM (Select * from PactLists Where AddDate>= '2008-11-1' And AddDate<= '2008-11-30')
GROUP BY (ItemFlag,Unit,UnitPrice)
查寻报错:"Group附近有错"

group by 后面的括号去掉再试试.

不用括号啊。·你把它括起来就代表整体L..!

去掉就可以进行分组查询

SELECT c.ItemFlag, c.Unit, c.UnitPrice, SUM(CONVERT(float, c.ProduceQuantity)) AS ProCount
FROM (Select * from PactLists Where AddDate>= '2008-11-1' And AddDate<= '2008-11-30') c
GROUP BY ItemFlag,Unit,UnitPrice
试试！！
不清楚你 PactLists 表是结构！

SELECT ItemFlag, Unit, UnitPrice, SUM(CONVERT(float, ProduceQuantity)) AS ProCount
FROM PactLists
Where AddDate>= '2008-11-1' And AddDate<= '2008-11-30'
GROUP BY ItemFlag,Unit,UnitPrice