请教一个简单的查询问题

[weixin_36088669]

上图是表中的数据 如何才能让查询出来的结果如下图 也就是说code相同的行都合并为一行 并且weight相加

[碧水幽幽泉]

select code ,sum(weight) as weight from trans group by code

[Rotel-刘志东]

select  code,sum(weight) as weight from trans 
group by code

[五更琉璃]

select code ,sum(weight) as weight  from trans group by code

[学海无涯-回头是岸]

如 楼上 sum加group by

[hp961218]

那么问题来了，怎么显示出这样子的格式

[yujiaxucheng]

SELECT CODE AS "code(车辆编码)", SUM(WEIGHT) AS "weight(载重)" 
FROM TRANS 
GROUP BY CODE

[ChinaITOldMan]

select code ,sum(weight) as weight from trans group by code

[yujiaxucheng]

引用 6 楼 hp961218 的回复:

那么问题来了，怎么显示出这样子的格式

不满足1NF了，除非……自己拼接。