查询重复数据
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)