SELECT
*
FROM
( SELECT DISTINCT * FROM table1 ORDER BY create_time DESC ) table1
GROUP BY
field1
ORDER BY
create_time DESC
MySQL GROUP BY分组按时间排序
于 2022-01-18 18:26:50 首次发布
SELECT
*
FROM
( SELECT DISTINCT * FROM table1 ORDER BY create_time DESC ) table1
GROUP BY
field1
ORDER BY
create_time DESC