mysql 删除重复数据只留一条

待删除表结构（表名test_hotel_change_hotels）

执行语句：

DELETE
FROM
	test_hotel_change_hotels
WHERE
	hotelid IN (
		SELECT
			hotelid
		FROM
			(
				SELECT
					hotelid
				FROM
					test_hotel_change_hotels
				GROUP BY
					hotelid
				HAVING
					count(hotelid) > 1
			) b
	)
AND id NOT IN (
	SELECT
		id
	FROM
		(
			SELECT
				max(id) AS id
			FROM
				test_hotel_change_hotels
			GROUP BY
				hotelid
			HAVING
				count(hotelid) > 1
		) a
)