Hi

After checking the query to find nth row in a table on this forum. I tried ( JUST TO LEARN) with rownum, what I have done is
1. select sal from emp where rownum=1 order by sal;
it gives me the 1st row. Then

IN ORDER TO GET 5TH ROW
2. select sal from emp where rownum=5 order by sal;
but it gives me no rows selected.
why this strange behavior.???

Please help me.

Is RowNum a column in your emp table?

_________________________
- Vijay G
Strive for Perfection

No vijay....

1. select sal from emp where rownum=1 order by sal;
it gives me the 1st row.... Then how do you say this works?

_________________________
- Vijay G
Strive for Perfection

Dont be insulted, but are there 5 rows in the table?

======================================
"They say, best men are molded out of faults,
And, for the most, become much more the better
For being a little bad."
--Shakespeare
======================================