sql删除某字段重复的数据保留id最小的数据

1. 查看某字段重复数据的id

SELECT
	id,
	count(*) 
FROM
	merchant_pos_info_copy1 
GROUP BY
	device_no DESC 
HAVING
	(
	count(*) > 0 
	)

2. 删除某字段重复的数据

DELETE 
FROM
	merchant_pos_info_copy1 
WHERE
	id NOT IN ( SELECT a.id FROM ( SELECT min( id ) as id FROM merchant_pos_info_copy1 GROUP BY device_no )a )