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

Home -> Community -> Usenet -> c.d.o.tools -> First 20 records only

First 20 records only

From: Jack <No_at_Mail.Please>
Date: Fri, 8 Jun 2001 12:08:27 +0100
Message-ID: <0n2U6.69731$662.285365@news1-hme0>

Hi
Can you please tell me how to 'select' only (the first) 20 records of a table?
is it ;

      select * from tableA sample (20)

Thanks Received on Fri Jun 08 2001 - 06:08:27 CDT

Original text of this message

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