sql 某一欄位 數量大於1 SELECT * FROM ecm_goods_spec AWHERE ( SELECT count( * ) FROM ecm_goods_spec BWHERE A.`goods_id` = B.`goods_id` ) >1 ...
sql 某一欄位 數量大於1
SELECT *
FROM ecm_goods_spec A
WHERE (
SELECT count( * )
FROM ecm_goods_spec B
WHERE A.`goods_id` = B.`goods_id`
) >1
