Organizational Research By

Surprising Reserch Topic

select nth row from a table in oracle


select nth row from a table in oracle  using -'sql,oracle'

How can I select the Nth row from a table in Oracle?

I tried

SELECT PRICE FROM AAA_PRICING WHERE ROWNUM = 2


but that didn't work. Please help!
    

asked Sep 9, 2015 by Debbie18R56
0 votes
10 views



Related Hot Questions

4 Answers

0 votes
NULL
answered Sep 9, 2015 by EnrDesailll
0 votes
NULL
answered Sep 9, 2015 by BebeTeaguer
0 votes
NULL
answered Sep 9, 2015 by AraDobie
0 votes
NULL
answered Sep 9, 2015 by VicBarksdal

...