CREATE TABLE with LIMITED RECORDS

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 - 18:23:11 CDT