删除表中重复数据，根据单个字段查重，id判断

delete from new_srv_userprofilebase where new_srv_userprofileid in (
select new_srv_userprofileid from (select new_srv_userprofileid ,new_name,row_number() over (partition by new_name order by new_srv_userprofileid) RowNum from new_srv_userprofilebase ) as t1 where RowNum = 2)