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

Home -> Community -> Usenet -> c.d.o.server -> Re: Limit lines from a query

Re: Limit lines from a query

From: Franz-Josef Vorspohl <fj.vorspohl_at_gmx.de>
Date: 2000/03/11
Message-ID: <38CA793B.DA372AAA@gmx.de>#1/1 






Hello Sybrand,



> The only way seems to be (and this will work only in 8i and upwards)

> select *

> from

> (select ...

>  from ...

>  order by ...

> )

> where rownum < n




We have Oracle 8.0.5.



I get a error message :-(
Received on Sat Mar 11 2000 - 00:00:00 CST












Original text of this message













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