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 )