07 2020 档案

sql 通过group by、sum聚合查询结果的排序
摘要：SELECT PeopleID,People, sum(Score) as Score, 'Rank' =dense_rank() over(order by SUM(Score) desc) FROM [dbo].[IntegralInputDetail] GROUP BY PeopleID,Pe 阅读全文
posted @ 2020-07-23 11:16 marisen 阅读(1978) 评论(0) 推荐(0) 编辑