Xref: alice comp.databases.oracle.misc:22513 Path: alice!news-feed.fnsi.net!newsfeed.direct.ca!news.bctel.net!not-for-mail From: "Thor" Newsgroups: comp.databases.oracle.misc Subject: Re: Select one row Date: Wed, 11 Nov 1998 17:07:03 -0800 Organization: BCTEL Advanced Communications Lines: 18 Message-ID: <72dc78$861$1@news.bctel.net> References: <364949b1.0@d2o204.telia.com> <364954BC.BB13151A@solution42.de> <72cspj$l1k$1@news01.btx.dtag.de> Reply-To: "Thor" X-Newsreader: Microsoft Outlook Express 4.71.1712.3 X-Mimeole: Produced By Microsoft MimeOLE V4.71.1712.3 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@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