22,206
社区成员
发帖
与我相关
我的任务
分享
;with CTE AS(
select * ,
Row_Number() over(partition by C1,C2,C3 order by (select 1)) as RNr
from table1
)
select * from CTE a where exists(select * from CTE where C1 = a.C1 and C2 = a.C2 and C3 = a.C3 and RNr > 1)
;WITH cte AS (
SELECT rn=ROW_NUMBER() OVER(PARTITION BY c1,c2,c3 ORDER BY GETDATE()),* FROM table1
)
SELECT * FROM cte WHERE rn>1
SELECT a.* FROM Table1 a JOIN (
select C1,C2,C3,COUNT(1) 重复次数 FROM Table1 GROUP BY C1,C2,C3 HAVING COUNT(1)>1
) b ON a.c1=b.c1 AND a.c2=b.c2 AND a.c3=b.c3
--这样就可以找出重复的数据了.