1.删除同一表中指定字段相同的记录,并保留一条
delete from t_ddt_rpt_time_alert_datas x
where x.rowid in (select max(t.rowid)from t_ddt_rpt_time_alert_datas t
group by t.id
having count(*) > 1)
1.删除同一表中指定字段相同的记录,并保留一条
delete from t_ddt_rpt_time_alert_datas x
where x.rowid in (select max(t.rowid)