>>21
oracle8iならこれがベストだと思っていたが....

select * from (select * from userm order by usernm) where rownum <= 20
minus select * from (select * from userm order by name) where rownum <= 10;

既出ならすまん。