delete from table as a where (select count(*) from table as b where b.username=a.username)>1

delete from table where username in (select username from (select username,count(*) from table group by username having count(*)>1))