【SQL开源代码栏目提醒】:网学会员--在 SQL开源代码编辑为广大网友搜集整理了:使用OVER子句和SUM函数根据订单编号分区聚合数据.sql绩等信息,祝愿广大网友取得需要的信息,参考学习。
USE db_
sql2005
GO
SELECT 订单编号,商品编号,订货数量
,SUM(订货数量) OVER(PARTITION BY 订单编号) AS '总计'
,COUNT(订货数量) OVER(PARTITION BY 订单编号) AS '计数'
,AVG(订货数量) OVER(PARTITION BY 订单编号) AS '平均'
,MIN(订货数量) OVER(PARTITION BY 订单编号) AS '最小'
,MAX(订货数量) OVER(PARTITION BY 订单编号) AS '最大'
FROM tb_Sale
WHERE 订单编号 IN('DD1305','DD1306')
GO