求一条SQL语句

[wwoo_1105]

有下列表存在
表名：student
共有四列：STUDENT_ID STUDENT_NAME DEGREE
要求查询此表中成绩排名第六位的学生资料

[piaoqifeng]

select * from student
where STUDENT_ID In
(
select top 1 STUDENT_ID from
(select top 6 * from student
order by 成绩 DESC) t
order by 成绩 ASC
)

[piaoqifeng]

没装数据库，没验证语句。呵呵

[Limpire]

select * from student a where (select count(DEGREE) from student where DEGREE>a.DEGREE) = 5

[$扫地僧$]

select top 1 * 
  from(select top 6 * from student  order by DEGREE DESC) T
order by DEGREE

[flyidealism]

create table student(studentId int,studentName varchar(20),degree int)
insert into  student 
select 1,'张三',80
union all
select 2,'李四',85
union all 
select 3,'王二',64
union all
select 4,'刘强',67
union all
select 5,'胡为',72
union all
select 6,'钟杨',93
union  all
select 7,'罗文',76
union all 
select 8,'张彬',86
union all
select 9,'王云',88


select top 1 * from
(
select top 6 *
from student 
order by degree )T 
order by degree desc

结果为：
2 李四 85