Re: Stupid SQL question

I don remeber much.. but i think you need to test rownum()

like:

select * form sometable
where rownum()<10;

i hope i am correct...

Tarek

Laurent TRESCAZES wrote:

> 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 - 15:05:25 CST