SELECT 会员id,sales,
Row_Number() OVER (ORDER BY sales desc ) rank1 ,—按照金额降序给个序号 分组就加 partition by sales
SUM(sales) OVER() AS total_sales,---- 增加一列总金额
SUM(sales) OVER(ORDER BY sales desc ) AS leiji_sales – 金额降序排列后计算累计金额
from xxtable
版权声明：本文为weixin_44788745原创文章，遵循CC 4.0 BY-SA版权协议，转载请附上原文出处链接和本声明。