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: Get first 10 records?

Re: Get first 10 records?

From: Yann CAUCHARD <yann.cauchard_at_spcconsultants.com>
Date: Wed, 17 Oct 2001 16:29:15 +0200
Message-ID: <9qk4hp$org$1@news2.isdnet.net> 





select ... from ... where rownum<=10;


hth



Yann



harry a écrit dans le message ...


>Using Oracle 8i 8.1.7

>

>Is it possible to return just the first say 10 records from a select

statment?


>

>thanks

>

>harry

Received on Wed Oct 17 2001 - 09:29:15 CDT












Original text of this message













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