select *
from t_hzdrp_sys_user u
where u.login_name in (select u.login_name
from t_hzdrp_sys_user u
group by u.login_name having count(*) > 1)
delete from t_hzdrp_sys_user where id='HZ81814a30f472800130f47281e90180'
from t_hzdrp_sys_user u
where u.login_name in (select u.login_name
from t_hzdrp_sys_user u
group by u.login_name having count(*) > 1)
delete from t_hzdrp_sys_user where id='HZ81814a30f472800130f47281e90180'