Hi,

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

Answers

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

-- Anonymous, February 16, 2001