select a,b from table order by b desc
--返回前十条
select a,b from ( select a,b from table order by b desc) where rownum < 11
select a,b from table order by b desc
--返回前十条
select a,b from ( select a,b from table order by b desc) where rownum < 11