Finding duplicate database entries

[karlovac]

Is there a smart SQL statement to find duplicate database entries in a mySQL db based on numerous table names?

I have the following table:

+------+----------+----------+---------------+
| a_id | a_showId | a_slotId | a_volunteerId |
+------+----------+----------+---------------+
|  395 |        2 |      553 |           261 |
+------+----------+----------+---------------+

a_id is the only one that's unique to every row. I want to find all instances where the other three columns are duplicated. So for example, if there was another case where:

a_showId was 2
a_slotId was 553
and a_volunteerId was 261

I need the a_id for that one.

-Antun

[nnichols]

Try this -

SELECT a_showId,a_slotId,a_volunteerId
FROM tbl_name
GROUP BY a_showId,a_slotId,a_volunteerId
HAVING COUNT(*) >1

This will only give you the duplicate data. You would then need to requery to get the multiple IDs for rows containg the duplicate data.

[karlovac]

Thanks!!!

That did it.

-Antun