Re: First 20 records only

From: Ian Ledzion <ian.ledzion_at_lgxbow.com>
Date: Fri, 8 Jun 2001 13:32:33 +0200
Message-ID: <9fqd4n$8k4$1@rex.ip-plus.net>

SELECT *
FROM tableA
WHERE ROWNUM <= 20

"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:32:33 CDT