not true, using where rownum <11 will do.
Nobody
Kenneth C Stahl <BlueSax_at_Unforgettable.com> wrote in message
news:3848447F.81611C2A_at_Unforgettable.com...
> 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
>
> In the SQL world there is no such concept as the "first 10 records" in a
> table. That is old flat file or dbase thinking. The only concept that is
> remotely relevant is processing the first 10 records that are returned by
a
> specific cursor.
>
>
Received on Mon Dec 06 1999 - 18:12:54 CST
