SQL Server 剔除表中重复的记录的方法记录

--delete from [T_SaleConfirmStage]  not in --select * from [T_SaleConfirmStage]delete from [T_SaleConfirmStage] where PID not in (select max(PID) from [T_SaleConfirmStage] group by  [CompanyID]		  ,[ContractID]		  ,[BFB]      		  ,[StageDes] 		  ,[AddAmount]      		  ,[Playtime]		 		  ,[WBSID]		  ,[IsDeleted]		  ,[Currency]		  ,[CreatedByUserID]		   ,stageid,orderID)