delete [Payment] from [Payment] inner join( select ID from (select *,ROW_NUMBER() over(partition by Policy_No,PTD_Start order by PTD_Start) as rowno from [Payment])T where rowno>1) T2 --查询行号大于1的记录
on [Payment].ID=T2.ID
