MySQL - select multiple maximum values

Question

I have a table called order which contains columns id, user_id, price. I would like to select each user's most expensive order - the order for which that user paid the highest price. I want to select order.user_id and order.price in the same query.

Answer 1

select user_id, max(price) from `order` group by user_id

Answer 2

SELECT order.user_id, A.price 
FROM `order`
LEFT JOIN 
(SELECT user_id, price FROM `order` ORDER BY price DESC) A USING (user_id)