下面给出的查询用于删除重复记录.根据您的要求修改以下给定的查询-

Given below is query for deleting duplicate records. Modify the given below query according to your requirements -

DELETE
FROM TempCountry
WHERE CountryID NOT IN
	(
	SELECT MIN(CountryID)
	FROM TempCountry
	GROUP BY CountryCode
	)

大概是这样的

Probably something like this

...Your Query

AND loc.imageurl NOT LIKE '%ss1.4sql.net%'