Posted by Plamen Ratchev on 03/07/07 18:08

Here is one way to accomplish this:

SELECT Field1, Field2
FROM TableA
WHERE Field1 IN
(SELECT Field1
FROM (SELECT DISTINCT Field1, Field2
FROM TableA) AS A
GROUP BY Field1
HAVING Count(*) > 1)

HTH,

Plamen Ratchev
http://www.SQLStudio.com

[Back to original message]