SQL基础问题，求帮忙。急急急！

Question

id 产品名 销量 成本 备注
1 水 100 5000 A厂家
2 水 200 7000 B厂家

如何根据产品名将他们合并成一条数据：
id 产品名 销量 成本 备注
1 水 300 12000 A厂家, B厂家

Answer 1

select min(id), 产品名，sum(销量),sum(成本) from 表名 group by 产品名

Answer 2

group by 产品名 其他的sum

Answer 3

https://bbs.csdn.net/topics/360129756

Answer 4

实用 sum函数，group by 产品名，实际SQL：Select min(ID)，产品名，sum(销量),sum(成本) from 表名 group by 产品名

Answer 5

select *,sum(销量)，sum(成本) from 表 group by 产品名

Answer 6

https://www.cnblogs.com/Snowfun/p/5895600.html 解决字符串

Answer 7

SELECT CityName,STUFF((SELECT ',' + UserName FROM aa subTitle WHERE CityName=A.CityName FOR XML PATH('')),1, 1, '') AS A
FROM aa A
GROUP BY CityName

Answer 8

INSERT INTO TableName
SELECT 产品名, (select sum(销量) from tablename where 产品名='水') AS 销量, (select sum(成本) from tablename where 产品名='水') AS 成本
FROM TableName
产品名='水'

DELETE FROM TableName WHERE 产品名 IN('水');

SELECT * FROM TableName

Answer 9

select 产品名，sum(销量),sum(成本) from 表名 group WHERE 产品名 IN('水');

Answer 10

SELECT id,产品名,SUM(销量),SUM(成本),GROUP_CONCAT(备注) FROM 表 GROUP BY 产品名

Answer 11

为什么不在代码里进行处理，sql处理效率低下

Answer 12

select *,sum(销量)，sum(成本) from 表 group by 产品名

Answer 13

SELECT MIN(a.id),a.name,SUM(a.num),SUM(a.money),GROUP_CONCAT(a.description) FROM goods a GROUP BY a.name
group_concat 用来拼接字符串

Answer 14

select *,sum(销量)，sum(成本) from 表 group by 产品名