To display n

^{th}row from a table say Emp:
select * from Emp where rownum< (n+1) MINUS select * from Emp where rownum < n

First select query will return first N rows and second
select query will return first N-1 rows and then subtract these two results which
gives only n

It is similar to Minus operation over sets^{th}row in the table.
For example if you want to display 5th row from emp table then:

select * from emp where rownum< 6 MINUS select * from emp where rownum < 5

SQL Minus Operation |