本文介绍了Sql查询获得最大的评级总和的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧! 问题描述 29岁程序员,3月因学历无情被辞! 亲爱的专家, 我有一张下面的表格,Dear Experts,I have a Table Give below,ITEM_ID | RATING----------------- 1| 5 1| 2 1| 5 1| 1 2| 5 2| 5 2| 5 3| 4 我需要一个Sql查询来获得最大等级的Item_ID ... 例如....I need a Sql query to get the Item_ID of largest sum of Rating...Eg....Sum of First Items Ratings = 5 + 2 + 5 + 1 = 13Sum of Second Items Ratings = 5 + 5 + 5 = 15Sum of Third Items Ratings = 4So my out put is = Item_ID = 2Coz, it having the highest rating 15 ... PLease帮助我.. 谢谢... DileepPLease help me..Thanks...Dileep推荐答案SELECT ITEM_ID, MAX(SUM(RATING)) AS HighestRate FROM TableNameGROUP BY ITEM_IDSELECT ITEM_ID, Points, RANK() OVER(ORDER BY Points DESC) AS [Rank]FROM ( SELECT ITEM_ID, SUM(RATING) AS Points FROM TableName GROUP BY ITEM_ID) AS T 更多关于:排名函数 [ ^ ]select ITEM_ID, Sum(RATING) As TotalRATING, Rank() over (order by Sum(RATING) desc) as CurrentRank from TableName group by ITEM_ID OutPut- ITEM_ID | TotalRATING | CurrentRank 2 | 15 | 1 1 | 13 | 2 3 | 4 | 3 谢谢 ZubairOutPut-ITEM_ID |TotalRATING |CurrentRank2 | 15 | 11 | 13 | 23 | 4 | 3ThanksZubair 这篇关于Sql查询获得最大的评级总和的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持! 上岸,阿里云!