SQL 中将多条相同数据统计成一条数据，如图

Question

比如第一列中2657有两行数据，我希望显示成一条数据，但IC_AMOUT这列的数据要累计相加。结果应该显示为：2657 元海瑞 -33.37
大神们能明白我的意思么？在线等答案

Answer 1

select 客户编码,客户简称,sum(ic_amount)
from 表
group by 客户编码,客户简称追问

select a.cm_code 客户代码,
a.cm_shortname 客户简称,
b.ic_amount 应收,
from ctr.csi_customer a,
bil.bil_income b
where a.cm_id = b.cm_id
group by a.cm_code,a.cm_shortname
如果是这样行吗？

追答

elect a.cm_code as 客户代码,
a.cm_shortname as 客户简称,
sum(b.ic_amount ) as 应收,
from ctr.csi_customer a,
bil.bil_income b
where a.cm_id = b.cm_id
group by a.cm_code,a.cm_shortname;这样可以，你写的不对，你都没有合计， 写group by会报错的

Answer 2

select 客户代码,客户简称,sum(IC_AMOUT) from 表
group by 客户代码,客户简称追问

select a.cm_code 客户代码,
a.cm_shortname 客户简称,
b.ic_amount 应收,
from ctr.csi_customer a,
bil.bil_income b
where a.cm_id = b.cm_id
group by a.cm_code,a.cm_shortname
如果是这样行吗？

Answer 3

SELECT t.客户代码,t.客户简称,SUM(t.ic_amout) as ic_amout FROM table_name t GROUP by t.客户代码,t.客户简称追问

select a.cm_code 客户代码,
a.cm_shortname 客户简称,
b.ic_amount 应收,
from ctr.csi_customer a,
bil.bil_income b
where a.cm_id = b.cm_id
group by a.cm_code,a.cm_shortname
如果是这样行吗？