mysql实现删除数据表重复值，保存最小id

查询重复数据

select max(account_id) as account_id,organ_idno,count(organ_idno) as nums from al_account group by organ_idno having count(organ_idno) > 1;

删除重复值

delete from al_account where account_id in (select t.account_id from (select max(account_id) as account_id from al_account group by organ_idno having count(organ_idno) > 1) as t);

delete from `user` 
where id not in (select id from (select min(id) as id from `user` group by `name`) t)