Xref: alice comp.databases.oracle.misc:22487
Path: alice!news-feed.fnsi.net!news.maxwell.syr.edu!newscore.univie.ac.at!newsfeed.de.ibm.net!ibm.net!ar4news.dlh.de!ar4dec01!news
From: "Bernd Dormann" <bernd.dormann@lhsystems.com>
Newsgroups: comp.databases.oracle.misc
Subject: Re: Select one row
Date: 11 Nov 1998 16:19:20 GMT
Organization: Lufthansa Systems GmbH
Lines: 15
Message-ID: <01be0d8e$f4ba9be0$866e01bd@mail>
References: <364949b1.0@d2o204.telia.com>
X-Newsreader: Microsoft Internet News 4.70.1161

select * from table
where ......
and rownum < 2

Kenneth Herskedal <kenneth.herskedal@trafNOSPAMsys.no> schrieb im Beitrag
<364949b1.0@d2o204.telia.com>...
> How can I select only the first row from a table.
> 
> My select statement returns several rows, but I'm only interested in the
> first row of the result set.
> 
> 
> 
> 
>