Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Quesry question

Quesry question

From: Cyb3rPunk <a.merola_at_inwind.it>
Date: Fri, 18 May 2001 12:13:09 +0200
Message-ID: <9e2r3n$pbg$1@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:13:09 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US