mysql sql文重複データをクエリーし、重複データを削除して1つだけ保持

**# 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の良い資源は公衆番号に注目してください