###这应该是效率最高的方法了
SELECT
class_id ,
substring_index(GROUP_CONCAT(id ORDER BY id DESC), ',', 1) maxid
FROM
student
GROUP BY class_id
###这应该是效率最高的方法了
SELECT
class_id ,
substring_index(GROUP_CONCAT(id ORDER BY id DESC), ',', 1) maxid
FROM
student
GROUP BY class_id
转载于:https://my.oschina.net/Diversity/blog/750068