Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how to display 5th record from a table

520277Sep 27 2006 — edited Sep 27 2006
Hi,
I want to display fifth record from a table in SQL.I thought it can be done using ROWNUM, but it is not working in the WHERE clause.I mean, the following query doesn't return anything....
SELECT * FROM TAB_NAME WHERE ROWNUM = 5;
If anybody knows, please tell me how can i get the 5th row from a table.

Thanks.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 25 2006
Added on Sep 27 2006
5 comments
1,866 views