如何在sqlserver数据库中删除主键相同的数据只留其一

delete a from ( select *,ps=row_number()over(order by getdate()) from SF_SalesManagerDataBase where ID='8ee7ff9d-2923-4ff5-8851-f8afbc29eb61') a where a.ps=2