这需要
MAX()在与主表连接的子查询中进行汇总。
SELECt tbl.id, tbl.val, tbl.updatedFROM tbl JOIN ( SELECt id, MAX(updated) as updated FROM tbl GROUP BY id) t2 ON tbl.id = t2.id AND tbl.updated = t2.updated
这需要
MAX()在与主表连接的子查询中进行汇总。
SELECt tbl.id, tbl.val, tbl.updatedFROM tbl JOIN ( SELECt id, MAX(updated) as updated FROM tbl GROUP BY id) t2 ON tbl.id = t2.id AND tbl.updated = t2.updated
名师互学网 版权所有 (c)2021-2022 ICP备案号：晋ICP备2021003244-6号
