sql表删除相同数据大于1的数据

with peopleInfo as(
select row_number() over(order by Username) rn,* from 表 where Username='321026196902232852' )
delete from peopleInfo where rn>1