DELETE FROM GWW_CWE_T_PredictQueue where id not in (select bid from (select min(id) as
bid from GWW_CWE_T_PredictQueue group by WarningTypeCode,UpStationId,UpFactorCode,UpMeasureDate) as b )
删除重复只保留一条
最新推荐文章于 2023-11-22 09:40:11 发布
DELETE FROM GWW_CWE_T_PredictQueue where id not in (select bid from (select min(id) as
bid from GWW_CWE_T_PredictQueue group by WarningTypeCode,UpStationId,UpFactorCode,UpMeasureDate) as b )