假设score中的值越大排名越靠前。
1、只求成绩
select min(a.score) No4_score
from (select distinct score
from student
order by score desc) a
where rownum < 5
;
2、查看档案
select *
from student
where score = (
select min(a.score) No4_score
from (select distinct score
from student
order by score desc) a
where rownum < 5
)
;
1.用SELECT ID,NAME,SCORE FROM STUDENT WHERE ROWNUM=4 ORDER BY SCORE,结果是没有记录。
2.select * from student where id =
( select max(id) from student
where id in
( select id from student
where rownum < 5 order by score desc
)
)
;,结果是缺少右括号,加了一个右括号,还是说缺少右括号。