查询数据库内重复数据 组合条件
1.查询出 数据表goods中 , name字段为 ’小儿感冒颗粒‘ 的商品重复数据
SELECT
`name`,
count( * )
FROM
lb_goods_category
GROUP BY
`name`
HAVING
count( `name` ) > 1
AND `name` = ‘小儿感冒颗粒’;
1.查询出 数据表goods中 , name字段为 ’小儿感冒颗粒‘ 的商品重复数据
SELECT
`name`,
count( * )
FROM
lb_goods_category
GROUP BY
`name`
HAVING
count( `name` ) > 1
AND `name` = ‘小儿感冒颗粒’;