mysql sql 语句 查询重复数据 并删除重复数据 只保留一条

**#例1：根据手机号customer_id查询所有重复的数据**
SELECT
    *
FROM
    aad_apply_main
WHERE
    customer_id IN (
        SELECT
            customer_id
        FROM
            aad_apply_main 
        GROUP BY
            customer_id
        HAVING
            count(customer_id) > 1
    ) ORDER BY customer_id DESC ;



#例2：根据手机号customer_id删除重复数据且只保留一条
DELETE
  FROM
    aad_apply_main
  WHERE
  	stdmerno='***' AND
    customer_id IN (SELECT
        *
    FROM
        (SELECT
            customer_id
        FROM
            aad_apply_main WHERE stdmerno='***' 
        GROUP BY customer_id
        HAVING COUNT(customer_id) > 1) t1)
    AND apply_no NOT IN (SELECT
        *
    FROM
        (SELECT
            MIN(apply_no)
        FROM
            aad_apply_main WHERE stdmerno='***' 
        GROUP BY customer_id
        HAVING COUNT(customer_id) > 1) t2)

**字段解释：**
	customer_id ： 根据此字段的重复来删除数据；
	stdmerno    ： 根据此字段来约束需要去重复的对象
	apply_no    ： 此字段为表的主键id字段

更多java好资源请关注公众号哦