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: Limitting result without ROWNUM

Re: Limitting result without ROWNUM

From: Matthias Matker <kernkoenig_at_arcor.de>
Date: Sat, 20 Jan 2007 16:57:17 +0100
Message-ID: <45b23bdc$0$18848$9b4e6d93@newsspool4.arcor-online.net> 





Matthias Matker schrieb:



> I have to limit the number of results without using ROWNUM or something 

> like that. One hint was to use "JOIN".

> 

> I have to select the 10 biggest persons from a table "persons"

> 

> id, firstname, lastname, size, age




Thank you for all your replies.



I will check them soon. ;-)



Matze
Received on Sat Jan 20 2007 - 09:57:17 CST












Original text of this message













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