sql group by 后取最后一条数据 ##方法一 SELECT * FROM table1 AS a, ( SELECT * FROM table1 GROUP BY id ORDER BY id DESC ) AS b WHERE a.id = b.id GROUP BY a.parent_id ##方法二 SELECT * FROM table1 AS a, ( SELECT max(id) as id FROM table1) AS b WHERE a.id = b.id