Question

tb表如下 id class sl 1 a 5 2 b 7 3 b 9 * 4 a 7 5 c 9 6 a 2 * 7

Answer 1

select * from tb t1 where not exists

(select * from tb where class=t1.class and id>t1.id)