Substitute of LIMIT clause (as used in MySQL) in O…
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)
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)