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)