Mysql 去除重复记录

delete saler as a from saler as a,(
          select min(id) as ID,cell_id,lac from saler group by cell_id,lac having count(*) > 1
      ) as b
      where a.cell_id = b.cell_id and a.lac = b.lac and a.id <> b.id;