How to select people who get maximum value order by value descending and exclude duplicate items

SELECT
userid
,title
,max(money) AS MAXMONEY
FROM
p2p_share_log
GROUP BY userid
ORDER BY MAXMONEY desc
LIMIT 0,10;

打完收工.

donate

感谢鼓励