已采纳回答 / 慕斯7158278
你这样写:SELECT goods_id,goods_name FROM tdb_goods GROUP BY goods_name HAVING count(goods_id) >= 2,通过name分组,看看哪个name对应了两条ID,
2018-04-27