How are we suppose to retrieve only the Nth row from a table?
SELECT * FROM table
WHERE rowid = (
SELECT rowid FROM table
WHERE rownum <= N
MINUS
SELECT rowid FROM table
WHERE rownum < N
);
oracle tips & tricks for database administration, database performance to optimize your oracle database
How are we suppose to retrieve only the Nth row from a table?
SELECT * FROM table
WHERE rowid = (
SELECT rowid FROM table
WHERE rownum <= N
MINUS
SELECT rowid FROM table
WHERE rownum < N
);