Re: First

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Wed, 4 Aug 2004 17:37:20 +0200
Message-ID: <41110225$0$15340$626a14ce@news.free.fr>

"Peter Plumber" <Klempner_at_gmxdot.net> a écrit dans le message de news:411100b6$1_at_e-post.inode.at...
> Hi,
>
> Does Qracle 9i support a SELECT that returns
> only a subset of the records
>
> something link
>
> SELECT FIRST 1 * FROM tablename
>
> thx
>
> Peter

Have a look at rownum pseudo-column.
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96540/sql_elements6a.htm#33158

--
Regards
Michel Cadot

Received on Wed Aug 04 2004 - 10:37:20 CDT