查询重复记录

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'