mysql重复数据下，删除一条重复数据

delete from information where id in (select id from (select max(id) as id,count(*) as ccc from information  GROUP BY encoding HAVING ccc>1 ) as tab)