mysql - 如何在SQL中找到临时列的总和？

Question

我有这个代码:

SELECT ID, Name, 100 AS TempColumn
FROM MyTable;

表格是这样的:

| ID | Name | TempColumn|
-------------------------
| 1  |  A   |   100     |
-------------------------
| 2  |  B   |   100     |
-------------------------
| 3  |  C   |   100     |
-------------------------
| 1  |  A   |   100     |
-------------------------
| 4  |  D   |   100     |
-------------------------

现在我想求 |TempColumn| 的总和其中 ID=1。所以它应该看起来像这样:

| ID | Name | TempColumn|
-------------------------
| 1  |  A   |   200     |
-------------------------

如何查询？

Answer 1

您可以对一个常数求和:

SELECT ID, Name, SUM(100) AS SumOfTempColumn
FROM MyTable
WHERE ID = 1
GROUP BY ID, Name;

<强> Example on SQL Fiddle