Supliment to my previuos Question : LUSENET : SQL Server Database Administration : One Thread


In my previuos question about Duplicate Records, We can find duplicate record using distinct. But i want to see only the Duplicate Records.

Thanks, Ravi.

-- Anonymous, February 15, 2001


SELECT DISTINCTROW First([Field1]) AS [Field1 Field], Count([Field1]) AS NumberOfDups FROM FROMtbl GROUP BY [Field1] HAVING Count([Field1])>1;

-- Anonymous, February 16, 2001

Moderation questions? read the FAQ