INSERT INTO 表1(字段1,字段2,字段3)
参数1,参数2,参数3
FROM
表2
ROWNUM = 1
要insert的value必须与select的结果一一对应
--表结构相同,即复制表
CREATE table B as SELECT * from A
--清空表A
DELETE FROM A
--去重后添加回表A
INSERT INTO A SELECT DISTINCT* FROMB
INSERT INTO 表1(字段1,字段2,字段3)
表2
ROWNUM = 1
要insert的value必须与select的结果一一对应
--表结构相同,即复制表
CREATE table B as SELECT * from A
--清空表A
DELETE FROM A
--去重后添加回表A
INSERT INTO A SELECT DISTINCT* FROMB