Information Storage and Retrieval: Query to retrieve Nth row from an Oracle table

Tuesday, January 19, 2010

The query is as follows:

select * from my_table where rownum <= n
MINUS
select * from my_table where rownum < n

Wandering Soul said...: SELECT b.*
FROM (SELECT ROWNUM rownum1, my_table1.*
FROM my_table my_table1) my_table2
WHERE my_table2.rownum1 = 10; January 27, 2010 at 9:02 PM