一行sql
SELECT * FROM(SELECT * FROM student ORDER BY create_time DESC LIMIT 10000) s GROUP BY name
解析:分为子查询和主查询,两个语句
(1)里面先进行排序,分组的时候会默认每个分组的第一个,limit 必须加,不加的话顺序不生效
SELECT * FROM student ORDER BY create_time DESC LIMIT 10000
(2)然后分组取第一条
SELECT * FROM s GROUP BY name