我在Oracle中建了一个成绩表a,我想通过SQL得到成绩最好的前10位人的ID,请问大侠该怎么做。
create table a
(
id number,
score number
);
------解决方案--------------------
- SQL code
select idfrom(select id from a order by score desc)where rownum <= 10
select idfrom(select id from a order by score desc)where rownum <= 10