Pages

▼

Tuesday, January 19, 2010

Query to retrieve Nth row from an Oracle table

The query is as follows:

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

1 comment:

  1. Wandering SoulJanuary 27, 2010 at 9:02 PM

    SELECT b.*
    FROM (SELECT ROWNUM rownum1, my_table1.*
    FROM my_table my_table1) my_table2
    WHERE my_table2.rownum1 = 10

    ReplyDelete