How do we find duplicate values in the table in MySQL ?

Answer 1

What do you really want to achieve? If you want to count the duplicate values, you can try experimenting with the GROUP BY clause selecting/projecting the COUNT of that column. If you want to cluster the duplicate values, you can do it with ORDER BY clause.

Answer 2

SELECT * FROM tablename GROUP BY fieldset

Answer 3

I think GROUP BY clause followed by HAVING would work. Well thanks for the answer Lambert.

Answer 4

Yes you are right Aqhil you are expertise in that