写一条复杂的sql语句

Question

select
    a.CourseID,
    a.StudentID,
    a.Achievement
from
    StudentAchievement a
where
    a.StudentID in (select 
                        top 2 StudentID 
                    from 
                        StudentAchievement 
                    where
                        CourseID = a.CourseID
                    order by
                        Achievement desc)
order by
    a.CourseID,a.Achievement

Answer 1

楼主,你的表中并没有课程的字段,怎查,如果有的话试一下以下的语句select studentid,courseid,achievement from studertachievement 
where select top 2 课程 from table_name order by studentid asc