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