SQL如何总结整数/数值在不同的行

Question

我试图合并整数和数值从不同的SQL行在同一表到一行，使他们总结。

| ID | Count | Total Payment
1 | 1  |     5 |         10.99
2 | 1  |     3 |          4.86
3 | 2  |     8 |         19.88
4 | 2  |     2 |         15.99
5 | 2  |     5 |          8.45
6 | 3  |     4 |         12.98
7 | 3  |    10 |         40.42

等我想总结上面的行成以下行。

| ID | Count | Total Payment
1 | 1  |     8 |         15.85
2 | 2  |    15 |         44.32
3 | 3  |    14 |         53.40

我该怎么做?

Answer 1

感谢HonyBadger和Mathieu Guindon。

正确的代码是:

SELECT [id], SUM([count]), SUM([total_payment])
FROM [table_name]
GROUP BY [id]
ORDER BY [count], [total_payment];