sql-server - Sql Server 订单最大值

Question

userID  point
111     20 
111     30 
222     40
222     50 

我想这样订购

222 50  
111 30

每个userId的最大值按DESC排序

Answer 1

按最大点值排序

SELECT userID, MAX(point) 
FROM [table] 
GROUP BY userID 
ORDER BY MAX(point) DESC