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 -> Re: First 20 records only

Re: First 20 records only

From: timkarnold <timkarnold_at_home.com>
Date: Fri, 08 Jun 2001 11:33:43 GMT
Message-ID: <rK2U6.63328$G5.13696986@news1.rdc1.md.home.com> 






select * from tableA where rownum < 21



"Jack" <No_at_Mail.Please> wrote in message
news:0n2U6.69731$662.285365_at_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:33:43 CDT












Original text of this message













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