sqlserver之多字段查重与重复只保留一个数据

SELECT
	* 
FROM
	crawler_property_copy1
WHERE 
	(user_mobile + estate_name ) IN ( SELECT user_mobile + estate_name FROM crawler_property_copy1 GROUP BY user_mobile, estate_name HAVING COUNT ( * ) > 1 ) ORDER BY user_mobile
	
	
DELETE 
FROM
	crawler_property_copy1 
WHERE
	( user_mobile + estate_name ) IN ( SELECT user_mobile + estate_name FROM crawler_property_copy1 GROUP BY user_mobile, estate_name HAVING COUNT ( * ) > 1 ) 
	AND id NOT IN (
	SELECT MAX ( id ) FROM crawler_property_copy1 GROUP BY user_mobile, estate_name HAVING COUNT ( * ) > 1 
	)