删除数据库重复记录

delete from Userinfo
   where userid  in (select  userid  from  Userinfo
   group  by  userid   having  count(userid) > 1)
and uid not in (select min(uid) from  Userinfo
   group by userid  having count(userid )>1)