Re: [GENERAL] CREATE TABLE AS

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