SQL_去重，插入不同数据

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;