查询各科成绩前三名的记录 分析如下: 1 select s.* from (select distinct Student.*,a.c_id, a.s_score, count( distinct b.s_score)+1 as rank 2 from Score a 3 left join Score b on a.c_id=b.c_id and a....