Unlike MySQL, there's no LIMIT clause. You can use oracle's ROWNUM to specifiy a greater than or less than condition, but you'll have to query the result set twice to build the upper and lower bounds.