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 转载于:https://www.cnblogs.com/su-king/p/5121926.html