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)