Re: set a number of records
From: MarkyG <markg_at_mymail.tm>
Date: Sat, 21 Jul 2001 21:56:24 GMT
Message-ID: <ab87195e.0106210144.75de4875_at_posting.google.com>
Date: Sat, 21 Jul 2001 21:56:24 GMT
Message-ID: <ab87195e.0106210144.75de4875_at_posting.google.com>
Hi,
This question is quite popular at the moment.
You can limit the number of rows returned by using the .... AND rownum
< 10 method.
However, this is flawed if you want a specific order (e.g by
surname).
Please log onto groups.google.com and do a search on 'Rank' and/or
'Top N'. You should find answers to previous postings (including a
detailed one from myself) there.
Mark
"Fabien VERISSIMO" <Fabien.VERISSIMO_at_sncf.fr> wrote in message news:<9gs3l9$ad$1_at_muguet.sncf.fr>...
> Hi,
>
> Could someone help me ?
>
> how set a number of records (a limit) in a SQL statement in ORACLE ("top"
> doesn't operate, "limit" too...)
>
> thank you to help me
Received on Sat Jul 21 2001 - 23:56:24 CEST