目前,我正在从事一个预测项目,以估计现金流量。SQL查询如下所示:
SELECT [Date] AS ds, SUM([Sales Amount]) AS y, [Item ID]
FROM dbo.[Table]
GROUP BY [Date], [Item ID]
ORDER BY ds;
为了预测销售额,我使用R包,该包严格要求必须至少有2个实例出现预测值(销售)。
但是,在我的查询中有一些实例,其中一项仅被交易一次。
您能帮我解决一个HAVING
或WHERE
条件,该条件或条件排除所有仅交易一次的所有商品吗?
谢谢!
我将添加一个计数并使用它:
SELECT ds, y, [Item ID]
FROM (SELECT [Date] AS ds, SUM([Sales Amount]) AS y, [Item ID],
COUNT(*) OVER (PARTITION BY [Item ID]) as cnt
FROM dbo.[Table]
GROUP BY [Date], [Item ID]
) t
WHERE cnt >= 2
ORDER BY ds;
本文收集自互联网,转载请注明来源。
如有侵权,请联系 [email protected] 删除。
我来说两句