How to SELECT exactely the 3rd row of a result table set ?
Assume I perform a SELECT statement with some WHERE clauses.
The resulting temporary result table set contains now 30 records.
Out of these 30 records I would like to get only the 3rd row.
Ok, I could do this be a cursor and walk over the first 2 rows. But is there a short way? I am thinking of a statement like
SELECT * FROM .... WHERE .... SKIP 2
If there is no 3rd rows an exception NO_ROWS_FOUND should be returned.
Additionally is there a way to return only the 3rd LAST rows of a result table set ?