共享一SQL面试题

Helen_px

select b.student_id,b.kc,grade,b.number
from (select student_id,kc,grade,number=(select count(*) from leanr where  kc=t.kc and grade>=t.grade )
      from leanr t) b
where b.number<=2
order by b.kc,b.grade desc,b.number

[ 本帖最后由 Helen_px 于 2007-11-7 11:32 编辑 ]