首页 > 数据库技术 > 详细

sql 开窗函数

时间:2016-05-20 13:07:12      阅读:296      评论:0      收藏:0      [点我收藏+]

mysql 不支持 分组子查询 over;

 

SELECT SalesOrderID, ProductID, OrderQty

   ,SUM(OrderQty) OVER(PARTITION BY SalesOrderID) AS ‘Total‘

   ,AVG(OrderQty) OVER(PARTITION BY SalesOrderID) AS ‘Avg‘

   ,COUNT(OrderQty) OVER(PARTITION BY SalesOrderID) AS ‘Count‘

   ,MIN(OrderQty) OVER(PARTITION BY SalesOrderID) AS ‘Min‘

   ,MAX(OrderQty) OVER(PARTITION BY SalesOrderID) AS ‘Max‘

FROM SalesOrderDetail

WHERE SalesOrderID IN(43659,43664);

 

sql 开窗函数

原文:http://www.cnblogs.com/zhangxiaoshuai/p/5511554.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!