select * from table where score in
(select top 3 score from table group by score order by score desc)
(select top 3 score from table group by score order by score desc)
-
追问:
- 呵呵……不好意思,能不能剖析一下这个语句啊,有点看不懂
-
追答:
- 把成绩分组,取3个最高的分数,然后根据分数查找学生信息。