上圖是表中的資料 如何才能讓查詢出來的結果如下圖 也就是說code相同的行都合并為一行 并且weight相加
uj5u.com熱心網友回復：
select code ,sum(weight) as weight from trans group by code
uj5u.com熱心網友回復：
如 樓上 sum加group byuj5u.com熱心網友回復：
select code ,sum(weight) as weight from trans group by codeuj5u.com熱心網友回復：
select code,sum(weight) as weight from trans
group by code
uj5u.com熱心網友回復：
SELECT CODE AS "code(車輛編碼)", SUM(WEIGHT) AS "weight(載重)"
FROM TRANS
GROUP BY CODE
uj5u.com熱心網友回復：
那么問題來了，怎么顯示出這樣子的格式uj5u.com熱心網友回復：
select code ,sum(weight) as weight from trans group by codeuj5u.com熱心網友回復：
不滿足1NF了，除非……自己拼接。
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/76470.html
標籤：基礎和管理