Sql Server Order Max Values

Question

userID  point
111     20 
111     30 
222     40
222     50 

I want to order like this

222 50  
111 30

every userId Max value order by DESC

Answer 1

To order by MAX point values

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