Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Select one row
What???
Rownum is a magic column (iso term for we don't like it!)
it assigns a sequential number to the row set returned by the SELECT
statement and has absolutely nothing to do with insert order. If it did it
would really be breaking the laws of relational calculus!!!
Thor HW
Nicolas Bronke wrote in message <72cspj$l1k$1_at_news01.btx.dtag.de>...
>Whith that you only get the first if you have additional where statements.
>The rownum represents the a serie in which kind you have inserted your
>records.
>
>eg. select * from table where rownum=1 returns the first inserted record
> select * from table where rownum=1 and fieldcondition returns the
>really first record
Received on Wed Nov 11 1998 - 19:07:03 CST