Substitute of LIMIT clause (as used in MySQL) in O…

Tuesday, 3 July 2007, 18:46 | Category : Database, Technology
Tags :

Substitute of LIMIT clause (as used in MySQL) in Oracle:

SELECT COL_NAME (SELECT COL_NAME, ROWNUM r from TABLE_NAME) WHERE r BETWEEN 10 AND 15

It will select 6 rows (10th to 15th inclusive)