rownum

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 Received on Mon Jan 03 2005 - 18:36:08 CST