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: HELP: SELECT TOP 10

Re: HELP: SELECT TOP 10

From: Red Hat Linux User <mauricio_at_samba.uss.UUCP>
Date: Tue, 20 Apr 1999 10:22:09 +0000
Message-ID: <Pine.LNX.3.96.990420101758.4049A-100000@samba.uss.UUCP> 






If you have an index on your ordering criteria, it will apply before the
rownum, so you can use "where rownum <= 10".
This means you must have the criteria as a column...



Mauricio



Mauricio Bellissimo Falleiros <mailto:mbf_at_uniconsult.com.br>



Uniconsult Sistemas e Servicos <mailto:uss_at_uniconsult.com.br>


Received on Tue Apr 20 1999 - 05:22:09 CDT












Original text of this message













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