SELECT a.*, c.`name` reservoirName
FROM
数据表 a
INNER JOIN ( SELECT SUBSTRING_INDEX(GROUP_CONCAT(id ORDER BY op_time DESC, id DESC),',',1) id FROM 数据表 GROUP BY code ) b ON a.id = b.id
qwer78 2021-10-27 15:00 原文
SELECT a.*, c.`name` reservoirName
FROM
数据表 a
INNER JOIN ( SELECT SUBSTRING_INDEX(GROUP_CONCAT(id ORDER BY op_time DESC, id DESC),',',1) id FROM 数据表 GROUP BY code ) b ON a.id = b.id