我要添加id的值。例如
ID Values----------b1 100c2 100c3 100b1 50
ID Values
----------
b1 100
c2 100
c3 100
b1 50
现在我想添加像这样的id 1值
ID Values----------b1 150c2 100c3 100
b1 150
应该为此编写哪个sql查询
brvekthn1#
查询
SELECT Table1.ID , SUM(Table1.Values) AS `values`FROM Table1GROUP BY Table1.IDorder BY Table1.ID
SELECT
Table1.ID
, SUM(Table1.Values) AS `values`
FROM
Table1
GROUP BY
order BY
结果
| ID | values || --- | ------ || b1 | 150 || c2 | 100 || c3 | 100 |
| ID | values |
| --- | ------ |
| b1 | 150 |
| c2 | 100 |
| c3 | 100 |
演示
1条答案
按热度按时间brvekthn1#
查询
结果
演示