Re: Select one row

From: Bernd Dormann <bernd.dormann_at_lhsystems.com>
Date: 11 Nov 1998 16:19:20 GMT
Message-ID: <01be0d8e$f4ba9be0$866e01bd@mail>

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

Kenneth Herskedal <kenneth.herskedal_at_trafNOSPAMsys.no> schrieb im Beitrag <364949b1.0_at_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.
>
>
>
>
>
Received on Wed Nov 11 1998 - 10:19:20 CST

This message: [ Message body ]
Next message: Dwight Crane: "How Do I Parse a String into an Array or PL/SQL Table"
Previous message: Kurt Laugesen: "Re: DATE datatype(Is the Time in there too?)"
In reply to: Kenneth Herskedal: "Select one row"
Next in thread: raji: "Re: Select one row"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

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