CREATE TABLE with LIMITED RECORDS

[Quoted] [Quoted] I would like to create a table to restrict only 50 records based on other [Quoted] table....How do I do that??

Like the following:

CREATE TABLE TEST
AS
SELECT * FROM ABC [Quoted] Since ABC table has about 60,000 records.......I would like to create [Quoted] portion of the records for testing...

Thanks in advance for your help.

Virginia Received on Mon Jul 19 1999 - 01:23:11 CEST