你使用方法错误,这样才是正确的。
insert into newtable select * from tljf.saleface2 WHERE to_char(enddate,'yymm') <> '0504'
insert into newtable select * from tljf.saleface2 WHERE to_char(enddate,'yymm') <> '0504'
as
select columnName...... from tableName
select * FROM tljf.saleface2 WHERE to_char(enddate,'yymm') <> '0504'
select * FROM 原表名 where 条件
关于建表插入,楼上几位的解答了。create table newtable as
select * FROM tljf.saleface2 WHERE to_char(enddate,'yymm') <> '0504'
yong ci fang fa ke yi fu zhi he yuan biao yi yang de biao jie gou .