我想要在a的地方直接拿到下面这个SQL数字的排名前五条的,不能用orderby 只能在a这个地方写sql
select
a
from (
select 82 a from dual union all
select 85 a from dual union all
select 86 a from dual union all
select 88 a from dual union all
select 22 a from dual union all
select 23 a from dual union all
select 65 a from dual union all
select 31 a from dual union all
select 34 a from dual union all
select 32 a from dual union all
select 88 a from dual
)b