SQL删除重复数据 

    delete from [EPLUSv2.0_Back4].[dbo].[T_StorageOrder] where Id in (
  SELECT Id from

    (select ROW_NUMBER() over

               (
                 partition by SaleOrderId
      　　　　   order by SaleOrderId
               ) RowNumber,* from [EPLUSv2.0_Back4].[dbo].[T_StorageOrder]

      ) a where a.RowNumber > 1 and a.OrderType=1)

 

posted @ 2016-08-25 15:28  Jasper_贾斯白  阅读(115)  评论(0)  编辑  收藏  举报