How to find duplicate value in MySQL

  • Posted on: 15 May 2017
  • By: jmu

Using HAVING after GROUP BY:

SELECT  product,COUNT(*) c FROM tb_product GROUP BY product HAVING c > 1;
English