SQL查询结果分类汇总
答案:1 悬赏:50 手机版
解决时间 2021-01-29 23:55
- 提问者网友：富士山上尢
- 2021-01-29 17:55
SQL查询结果分类汇总
最佳答案
- 五星知识达人网友：不如潦草
- 2021-01-29 19:00
SELECt A.*, COUNT(A.货号) AS 货号汇总, (A.规格汇总/ COUNT(A.货号)) AS 比例 FROM
(
select GoodsNO as 货号,GoodsName as 品名,SpecName as 规格,SUM(SellCount) as 规格汇总 from V_SSTTradeGoodsList where DateDiff(dd,Tradetime,getdate())<=30
GROUP BY GoodsNO,GoodsName,SpecName
)A追问Column 'A.货号' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause
这样报错的，不明白什么意思，朋友可以帮我再检查一下吗追答不知道你的是什么数据库哦
(
select GoodsNO as 货号,GoodsName as 品名,SpecName as 规格,SUM(SellCount) as 规格汇总 from V_SSTTradeGoodsList where DateDiff(dd,Tradetime,getdate())<=30
GROUP BY GoodsNO,GoodsName,SpecName
)A追问Column 'A.货号' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause
这样报错的，不明白什么意思，朋友可以帮我再检查一下吗追答不知道你的是什么数据库哦
我要举报
如以上问答信息为低俗、色情、不良、暴力、侵权、涉及违法等信息，可以点下面链接进行举报！
大家都在看
推荐资讯