SELECt a.* FROM test a WHERe a.attendence = 1 AND NOT EXISTS (select 1 from test where name = a.name and id > a.id and attendence = 1)GROUP BY name
甚至可能不再需要该组。
![SQL：GROUP BY记录，然后从每个组获取最后一条记录？[复制]](http://www.mshxw.com/aiimages/31/660284.png "SQL：GROUP BY记录，然后从每个组获取最后一条记录？[复制]")
SELECt a.* FROM test a WHERe a.attendence = 1 AND NOT EXISTS (select 1 from test where name = a.name and id > a.id and attendence = 1)GROUP BY name
甚至可能不再需要该组。
名师互学网 版权所有 (c)2021-2022 ICP备案号：晋ICP备2021003244-6号
