一般我们分组时候前面要使用聚合函数 GROUP_CONCAT(默认逗号连接),sum等
SELECT
`name`,
SUM( price ) AS price
FROM
`commodity`
GROUP BY
`name`
ORDER BY
price DESC
SELECT
`name`,
GROUP_CONCAT(price separator "-")
FROM
commodity
GROUP BY
`name`
#默认为逗号连接
SELECT
`name`,
GROUP_CONCAT(price)
FROM
commodity
GROUP BY
`name`