mysql 查询表字段相同数据
SELECT
Product_name,
Product_id,
Product_no
FROM
mei_product a
WHERE
(
(
SELECT
COUNT(*)
FROM
mei_product
WHERE
Product_name = a.Product_name
) > 1
)
AND a.Product_is_deleted = 0
ORDER BY
Product_name DESC