how to display 5th record from a table
520277Sep 27 2006 — edited Sep 27 2006Hi,
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.