How to find duplicate rows in a table?

Question

Possible Duplicate:
MySQL Duplicate rows
Displaying duplicate row numbers

Can anybody tell me how to find duplicate rows in a table if there is not any primary key column in the table?

we are not psychic here. Please add more details on your question. — John Woo, Oct 15 '12 at 06:28

score 1 · Answer 1 · answered Oct 15 '12 at 06:34

1

For Table with columns Field1, Field2:

SELECT FIELD1, FIELD2
FROM Table
GROUP BY FIELD1, FIELD2
HAVING COUNT(*)>1

answered Oct 15 '12 at 06:34

alex

1 Answers1