sql 删除两条完全相同的记录 delete a from ( select *,ps=row_number()over(PARTITION by cCaption order by getdate()) from AA_ColumnDic where ckey='r003')a where a.ps=2