[turba] feature request

Amith Varghese amith@xalan.com
Wed Oct 9 15:56:48 2002


> I know mysql supports the LIMIT keyword to control the size of
> the result set, but I'm fairly certain Oracle doesn't.  

In ORACLE if you want to limit the number of results you would use ROWNUM.  So
if you wanted items 50 to 100 you would do the following

SELECT bar.rn, bar.coldata FROM (
   SELECT ROWNUM rn, coldata FROM foo
} bar
WHERE bar.rn BETWEEN 50 AND 100

Amith