删除表中重复记录

1. delete from tb_user
2. where
3. username in(select username from tb_user group by username having count(username)>1)and
4. id not in(select min(id) from tb_user group by username having count(username)>1)