select * from 学生成绩表CJ as a
where 总成绩 in (select top 3 总成绩 from 学生成绩表CJ where 班=a.班 order by 总成绩 desc);