• 分组获取id最大一条

分组获取id最大一条

SELECT * FROM tb_dept td,(SELECT max(id) id FROM tb_dept GROUP BY parent_id) md 
where td.id = md.id;