mysql 删除重复数据

DELETE
FROM
 tb1
WHERE
 id NOT IN (
  SELECT
   dt.minno
  FROM
   (
    SELECT
     MIN(id) AS minno
    FROM
     tb1
    GROUP BY
     user_id,plan_id,balance,date
   ) dt
 )

1