Re: First 20 records only

select * from tableA
where ROWNUM <21;

Anthony

Jack wrote:

> 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:54:35 CDT