Re: CREATE TABLE with LIMITED RECORDS

create table test as
  select *
    from abc
    where rownum <= 50;

In article <97431316_at_NEWS.SAIC.COM>,
  "Tay, Virginia" <htay_at_geocities.com> 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
>
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Mon Jul 19 1999 - 04:01:04 CEST