Re: First

From: Rene Nyffenegger <rene.nyffenegger_at_gmx.ch>
Date: 4 Aug 2004 16:32:51 GMT
Message-ID: <slrnch23tm.vk.rene.nyffenegger@zhnt60m34.netarchitects.com>

> Hi,
>
> Does Qracle 9i support a SELECT that returns
> only a subset of the records
>
> something link
>
> SELECT FIRST 1 * FROM tablename
>
> thx
>
> Peter

Additionally, to the rownum suggested by others, there is the row_number() over (...) analytical function.

The problem with rownum is that it doesn't work together with a order by clause. Well, it does, but most of the time, it doesn't return what was intended.

Rene

-- 
  Rene Nyffenegger
  http://www.adp-gmbh.ch/

Received on Wed Aug 04 2004 - 11:32:51 CDT