select * from sometable order by name limit 20,10This allows me to get the 21st to the 30th rows (meaning skip the first 20, give the next 10). The rows are already selected after the "ORDER BY" so it starts on the 20th name alphabetically. But in Oracle, the only thing that comes close is the "ROWNUM" pseudo-column, which is evaulated before "ORDER BY", which gives us this:
select * from sometable where rownum <= 10 order by nameThat gives us a random set of rows ordered by name. That's what I don't want. Any help here?