共享一SQL面试题

李玮123456

如果考虑到一样的分数，楼上的sql应该修改下
select b.id,b.kc,grade,b.number
from (select id,kc,grade,number=(select count(*) from learn where  kc=t.kc and grade>t.grade )
      from learn t) b
where b.number<=1
order by b.kc,b.grade desc,b.number