删除多个字段重复的数据

SELECT *
FROM
 表名
WHERE
 (
  vip_phone,
  change_cause,
  occur_time,
  change_member_points
 ) IN (
  SELECT
   t.vip_phone,
   t.change_cause,
   t.occur_time,
   t.change_member_points
  FROM
   (
    SELECT
     vip_phone,
     change_cause,
     occur_time,
     change_member_points
    FROM
     表名
    GROUP BY
     vip_phone,
     change_cause,
     occur_time,
     change_member_points
    HAVING
     count(1) > 1
   ) t
 )
AND id NOT IN (
 SELECT
  dt.minid
 FROM
  (
   SELECT
    min(id) AS minid
   FROM
    表名
   GROUP BY
    vip_phone,
    change_cause,
    occur_time,
    change_member_points
   HAVING
    count(1) > 1
  ) dt
)