Aggregate keeping the row with the max value

Suppose 开发者_如何学Cyou have the following schema (id, user_id , score). How can I take per each user the row with max score and then order all row for score. In other word I want a ranking where ea