mysql 查找多个值并且取最大值一个和分组

SELECT
    eco_truename,
    eco_uid,
    max(checkup_time) AS time
FROM
    es_checkup_order
WHERE
    checkup_time < 1469944460
GROUP BY
    eco_uid
ORDER BY
    checkup_time DESC

 

转载于:https://www.cnblogs.com/wtcl/p/7452834.html