更正: select * from (select * from 学生 order by 成绩 DESC) where rownum < 6
select * from 学生 where rownum < 6 order by 成绩
select * from 学生 where rownum <= 5 order by 成绩 DESC
select * from (select * from 学生 order by 成绩 desc) where rownum<=5 考虑到可能有成绩相同的 可以用 select * from (select t.*,dense_rank() over (order by 成绩 desc) as r from 学生 t ) where r<=5
select * from
(select * from 学生 order by 成绩 DESC)
where rownum < 6
考虑到可能有成绩相同的
可以用
select * from (select t.*,dense_rank() over (order by 成绩 desc) as r from 学生 t ) where r<=5