Re: [GENERAL] CREATE TABLE AS

[David Warnock]

Chai,

Just miss out the order by, it has no meaning in a table definition.

ie 

Create table blah2 as
select pin from tbs_billing_record
where date(start_time) between '01-JAN-2000' and '23-JAN-2000';

Dave

************