SQL Server 删除重复记录,适合2005以后版本

WITH 库存单 As
(
  Select 库存单流水号,检验单据编号,物料编号,批次,筛选编号
    , ROW_NUMBER() OVER(Partition By 库存单流水号,检验单据编号,物料编号,批次,筛选编号 Order By 库存单流水号) AS RN
    , RANK() OVER(Partition By 库存单流水号,检验单据编号,物料编号,批次,筛选编号 Order By 库存单流水号) AS RNK
  FROM TDMS_YQJ_RKMX

)

DELETE FROM 库存单 WHERE rn<>rnk;