-- 添加告警临时表的唯一索引 列有资源id、时间
ALTER TABLE `b_alarm_trend_temporary` ADD CONSTRAINT unique_resId_and_createTime UNIQUE(resId,createTime);

-- 删除告警临时表重复数据的
delete from b_alarm_trend_temporary where id not in (select id from (select count(1) as number,id,createTime,resId from b_alarm_trend_temporary  group by createTime,resId having number=1) as c);

--查询告警临时表又没重复数据
select count(1) as number,id,createTime,resId from b_alarm_trend_temporary  group by createTime,resId having number>1;