Re: Quesry question

Note that this method WON'T produce the required results if you're attempting to order the data. If you also want to use an order by clause you'll need to use a subselect, for example -

select * from (select * from mytable order by mycolumn) where rownum < 10;

John.

"Hubert" <h.lentaigne_at_free.fr> wrote in message news:aF6N6.1120$eA7.1547376_at_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 - 10:20:20 CDT