sql：查询课程号'0312091006'成绩排名第5到第10之间的学生学号

select top 6 sno  from (select top 10 sno,mark from student_Course
where ccno='0312091006' order by mark desc) as  tmp order by mark asc