Find Duplicates (Where Multiple Rows Match) 1

[T0AD]

I have a simple query like this:

SELECT ColA, ColB, ColC FROM TableA

I want to return all of the rows where there is more than 1 row where the values in these three columns are the same, ordered by ColA (including the duplicate rows!).

Any ideas?

There's a thin line between genius, and insanity!

 

[RiverGuy]

SELECT a.*
FROM TableA a

INNER JOIN

(SELECT ColA, ColB, ColC
FROM TableA
GROUP BY ColA, ColB, ColC
HAVING COUNT(*) > 1) b

ON a.ColA = b.ColA AND a.ColB = b.ColB AND a.ColC = b.ColC
ORDER BY a.ColA

 

[T0AD]

Thank you.

There's a thin line between genius, and insanity!