Re: CREATE TABLE with LIMITED RECORDS

CREATE TABLE TEST AS
SELECT * FROM ABC
WHERE ROWNUM < 51;

"Tay, Virginia" wrote:
>
> Hi,
>
> I would like to create a table to restrict only 50 records based on other
> table....How do I do that??
>
> Like the following:
>
> CREATE TABLE TEST
> AS
> SELECT * FROM ABC
>
> Since ABC table has about 60,000 records.......I would like to create
> portion of the records for testing...
>
> Thanks in advance for your help.
>
> Virginia
Received on Sun Jul 18 1999 - 20:13:34 CDT