Q:

Get all the records that are duplicates not just the list of them Mysql

I can do
Select FieldA,FieldB,FieldC,Count(*) from TableA Group By FieldA,FieldB having count(*)>1

Which will give me a list of all the FieldA,FieldB duplicates with a count for each. What I need is all the records in that subset. If a specific FieldA,FieldB combo has a count of 3 I need to see all 3 of those records.  I've tried various joins to no avail.

A:

select a1.* 
from TableA a1
join
(
   Select FieldA, FieldB
   from TableA 
   Group By FieldA, FieldB 
   having count(*) > 1
) a2 on a1.FieldA = a2.FieldA
    and a1.FieldB = a2.FieldB

Join the same table on the result of the grouped one.

