I don't know if Oracle changed recently, but the last few times I used it, it was incredibly annoying having to put everything in a subquery to get a LIMIT-type operation to work AFTER the sort, so that you could use their ROWNUM. For example, to get the first 50 rows of a SELECT result. Their ROWNUM worked BEFORE the ORDER BY, so to get the 1st 50 rows, you had to put the query in a subselect, and say SELECT ... where ROWNUM <= 50.
I love OFFSET ... LIMIT in PostgreSQL! I do a lot of web applications, and it is incredibly handy to page output with.
Susan
---------------------------------------------------- Tiered Data Protection Made Simple http://www.overlandstorage.com/ ----------------------------------------------------
