snd-escloud/sql/20200423.sql

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