suit 为类别,ID为主键自增,score为想要的值
select * from tbl_skin_detail a where
2>(select count(*) from tbl_skin_detail b where b.suit=a.suit and b.id>a.id)
order by a.suit,a.id desc;