UPDATE ic_contract_floor SET del_flag = 0 WHERE id IN ( SELECT a.id FROM ( SELECT * FROM ic_contract_floor a WHERE EXISTS ( SELECT update_time FROM ic_contract_floor WHERE a.update_time = update_time GROUP BY update_time HAVING count( * ) >= 2 ) ) AS a ) update project_application set pass = null