sql 某一字段 数量大于1
SELECT *
FROM ecm_goods_spec A
WHERE (
SELECT count( * )
FROM ecm_goods_spec B
WHERE A.`goods_id` = B.`goods_id`
) >1
内容来源于网络如有侵权请私信删除
- 还没有人评论,欢迎说说您的想法!