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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Limit a result list

Re: Limit a result list

From: Alexander Zimmer <zimmer_at_hollomey.com>
Date: Wed, 4 Dec 2002 11:59:14 +0100
Message-ID: <MPG.1857fe61a1217ac89896d2@news.cis.dfn.de> 





oracle_at_banholzer.de wrote...


> 

> Hm, so I did an extra SELECT-Statement around, but the two Statements

> still have not the same result (the rownum is separated from the order

> in this statements, isn't it?):




The result should be the same, but the order may be not. If this poses a 
problem, you should add a "global" order by to the result.



Anyway, the SET of selected rows should be identical in both cases.



Alex
Received on Wed Dec 04 2002 - 04:59:14 CST












Original text of this message













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