mysql查询重复字段

SELECT * FROM products_providers WHERE product_id IN ( SELECT product_id  FROM products_providers GROUP BY product_id HAVING COUNT(product_id) >1) ;