解析:
将去重的数据和未去重的数据联查,去重掉的那部分肯定查不到,找到对应的id,删除即可
本SQL 不适用数据量太大的表
DELETE FROM hot_propertys WHERE id in (
SELECT
b.id
FROM
(SELECT id FROM hot_propertys GROUP BY level_one, level_two, level_three ) a
RIGHT JOIN (SELECT id FROM hot_propertys ) b ON a.id = b.id
WHERE
a.id IS NULL
)