Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Select one row

Re: Select one row

From: Thor <thor_at_echidna.net>
Date: Wed, 11 Nov 1998 17:07:03 -0800
Message-ID: <72dc78$861$1@news.bctel.net>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US