Re: Spooky SQL
From: Ayokunle Giwa <kgiwa_at_psn.net>
Date: Sun, 23 May 1999 06:55:01 -0700
Message-ID: <374808B5.5BC08A02_at_psn.net>
Date: Sun, 23 May 1999 06:55:01 -0700
Message-ID: <374808B5.5BC08A02_at_psn.net>
Using where rownum <5 destroys the ordering of the top 5, PL/SQL is the best bet.
Jaffri Ibrahim wrote:
> You're best to use PL/SQL or any procedural language to get the what you
> want. SQL in itself would
> normally return as many rows as possible to the statement. You could put a
> WHERE clause such as
>
> WHERE
> rownum <=5
>
> but this is non-standard SQL
>
> **** Posted from RemarQ - http://www.remarq.com - Discussions Start Here (tm) ****
Received on Sun May 23 1999 - 15:55:01 CEST