Re: rownum

On Mon, 03 Jan 2005 16:36:08 -0800, db2group88_at_yahoo.com wrote:

> hi, we are using oracle 10g, here is the wierd thing i don't
> understand, i do "select rownum, name from admin.test", i can see the
> result value of rownum is 1 and 2, and both columns has data in it, but
> when i do "select name from admin.test where rownum=2", i can't get the
> data back, i do "select name from admin.test where rownum=1", the data
> is returned, can someone help me? thanks

Stated like that, I conclude that

1. you do not understand that rownum is generated dynamically at query time (and will be different for each query, even if the values seem the same);
2. you may be reading significance into the value of ROWNUM that doesn't exist;
3. you may be attempting to extract information incorrectly.

If this is ot just a hypothetical/learning question, you would get the best answers if you describe what business logic or function you are trying to accomplish (and provide the table definition).

lol/FGB Received on Mon Jan 03 2005 - 19:34:59 CST