SELECT *
FROM TABLEName SA
INNER JOIN ( C1 ,
C2
FROM TABLEName
GROUP BY C1,
C2
HAVING COUNT(1) > 1
) data ON data.C1= sa.C1
FROM TABLEName SA
INNER JOIN ( C1 ,
C2
FROM TABLEName
GROUP BY C1,
C2
HAVING COUNT(1) > 1
) data ON data.C1= sa.C1
AND data.C2= sa.C2