I need to get the RecID of a record where it could have duplicates related to columns A, B and C.
Anything like this does not work.
Is there a way or what is the best way to do that?
SELECT RecID FROM (Select A, B, C FROM tableX GROUP BY A, B, C);
SELECT RecID FROM (Select A, B, C FROM tableX GROUP BY A, B, C);
SELECT * FROM
( SELECT COUNT(*) AS cnt, GROUP_CONCAT( RecID ) FROM tableX GROUP BY A, B, C )
WHERE cnt > 1
SELECT FIRST( RecID ) FROM tableX GROUP BY A, B, C;