Re: Quesry question

From: Hubert <h.lentaigne_at_free.fr>
Date: Fri, 18 May 2001 10:17:42 GMT
Message-ID: <aF6N6.1120$eA7.1547376@nnrp5.proxad.net>

Try

Select * from <table> where rownum < 10

Hubert

"Cyb3rPunk" <a.merola_at_inwind.it> wrote in message news:9e2r3n$pbg$1_at_fe2.cs.interbusiness.it...
> Hiya all!
>
> I have a quesry question...
>
> On my MS SQL server I have made this query:
>
> Select TOP 10 * from <table>
> and it returns the first 10 results (in the resultset) of the query..
>
> Now I have the same DB on Oracle 8i, but the query doesn't work because it
> seems not to accept the "TOP 10" instruction.
>
> Can someone help me?
>
> Bye
>
> Alex
>
>
>
Received on Fri May 18 2001 - 05:17:42 CDT