SQL 表中把相同的两行合并

Question

例如，表中的 FacilityId 有两个1111 并且 TypeName 都为运行，那么得到的结果应该是前两行合并为一行，shijianduan那一列中60+240 。其它都不变。就是把FacilityId 和TypeName 两行同时都相等的行合并。

Answer 1

select TypeCode,TypeName ,sum(shijianduan),FacilityId
from 表名
group by FacilityId ，TypeName ，TypeCode

Answer 2

select typecode ,Typename, sum(shijianduan) as time,facilityid
from tablename
group by typecode ,typename,facilityid

Answer 3

select FacilityId ,TypeName ,sum(shijianduan)
from table
group by FacilityId ,TypeName

Answer 4

典型的聚合应用。
select TypeCode, TypeName, sum(shijianduan), FacilityId from table group by TypeCode, TypeName, FacilityId本回答被网友采纳