For quite a while I've been frustrated with Oracle's lack of doing limit and offset in an easy single query. This always made it tedious to display paged results from a database query in a web page. Today, after looking on the web for the xth time, I stumbled into a query that seems to solve this.

So without further ado, here it is for those that have been searching for it also:

SELECT * FROM (
    SELECT ROW_NUMBER() OVER(ORDER BY column1) LINENUM, column1, column2
    FROM MyTable
    ORDER BY column1
)
WHERE LINENUM BETWEEN 100 AND 200;