Re: Stupid SQL question

Try

select * from the_table where rownum < 11;

HTH Rod J. Stewart

Laurent TRESCAZES <ltrescazes_at_peaktime.fr> wrote in message news:383C3F57.F98D2CCC_at_peaktime.fr...
> Hi eveybody,
>
> Does someone knows how to write a SQL sentence that return for example
> the first 10 records of table that includes many records
>
> I try to remember my SQL class but it's far away #8-)
>
> Best regards
>
> Laurent
>
Received on Wed Nov 24 1999 - 20:12:17 CST