04/05/02 16:22
>>327
ソート後指定件数取得
select aaa,bbb
from (
select aaa,bbb
from table
where aaa = 'zzz'
order by bbb
)
where rownum <= 20
04/05/02 16:22
>>327
ソート後指定件数取得
select aaa,bbb
from (
select aaa,bbb
from table
where aaa = 'zzz'
order by bbb
)
where rownum <= 20