sql批量去重语句

----查询重复数据

SELECT [1].tmStr,[1].flowId FROM dbo.table AS [1]
INNER JOIN dbo.table  AS [2] ON [1].tmStr = [2].tmStr where [2].cls= 1
AND [1].flowId > [2].flowId and [1].cls= 1

-----删除重复数据 

delete table 
where flowId in (
SELECT  [1].flowId FROM dbo.table  AS [1]
INNER JOIN dbo.table  AS [2] ON [1].tmStr = [2].tmStr where [2].cls= 1
AND [1].flowId > [2].flowId and [1].cls= 1
)