Re: set a number of records
From: Daniel A. Morgan <dmorgan_at_exesolutions.com>
Date: Sat, 21 Jul 2001 21:56:20 GMT
Message-ID: <3B31A082.77788262_at_exesolutions.com>
Date: Sat, 21 Jul 2001 21:56:20 GMT
Message-ID: <3B31A082.77788262_at_exesolutions.com>
Fabien VERISSIMO wrote:
> Hi,
>
> Could someone help me ?
>
> how set a number of records (a limit) in a SQL statement in ORACLE ("top"
[Quoted] [Quoted]
> doesn't operate, "limit" too...)
>
> thank you to help me
SomeNumber INTEGER := 101;
SELECT *
FROM mytable
WHERE rownum < SomeNumber;
Will return 100 rows.
Daniel A. Morgan Received on Sat Jul 21 2001 - 23:56:20 CEST