Tuesday 2 December 2014

Find Duplicate records based on any field mysql


Find Duplicate records based on any field mysql

The following will find all product_id that are used more than once. You only get a single record for each product_id.

SELECT product_id FROM oc_product_reward GROUP BY product_id HAVING count( product_id ) >1

No comments: