Re: set a number of records

In article <9gs3l9$ad$1_at_muguet.sncf.fr>, "Fabien says...
>
>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
>
>
select *
  from ( YOUR_QUERY_GOES_HERE )
 where rownum <= :n;

eg:

select *
  from ( select * from emp order by sal )  where rownum <= :n;

--
Thomas Kyte (tkyte_at_us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp