SQL_去重,插入不同数据

2014-11-24 15:47:47 · 作者: · 浏览: 0
SQL_去重,插入不同数据
删除重复数据
delete from T_COMMON_079_SHOW_SCREEN t where t.rowid in(select max(rowid) from T_COMMON_079_SHOW_SCREEN group by SCREEN_ID having count(SCREEN_ID)>
1);

插入不同数据
INSERT into "T_COMMON_006_MAIN_ATTACH_copy" select DISTINCT t.* from T_COMMON_006_MAIN_ATTACH t;