叹为观止的sql语句

SELECT user_id, order_id, order_date, amount
FROM orders
WHERE (SELECT COUNT(*) FROM orders o WHERE o.user_id = orders.user_id AND o.order_date < orders.order_date
) = 1
ORDER BY user_id, order_date

阿里渣渣研发组群主分享