输入命令： SELECT a.goods_id,a.goods_name FROM tdb_goods AS a LEFT JOIN (SELECT goods_id,goods_name FROM tdb_goods GROUP BY goods_name HAVING COUNT(goods_name)>1) AS b ON a.goods_name = b.goods_na
代码为：SELECT goods_id , goods_name FROM tdb_goods GROUP BY goods_name;报错为：ERROR 1055 (42000): Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 't2.tdb_goods.g
