Re: Top 10 recordsets

select * from <table> where ROWNUM<=10;

Bye

Jens Seifert <jens.seifert_at_allianz.de> wrote in message news:950007477.664453_at_rsx2668...
> Hello,
>
> how can I select in a SQL-Query the top10 recordsets from a table?
> I use ORACLE8.
>
> Thanks, Jens
>
>
>
>
Received on Thu Feb 10 2000 - 08:20:10 CST