如何获得值的总和在MySQL

Question

我有表：

id  name  amount 
-------------------------- 
1   abc  1 
2   abc  2 
3   abc  -3 
4   def  4 

我想名字的每一个量的总和== ABC，我的意思是1 + 2 +（ - 3）= 0;

如何在MySql中做到这一点？

Answer 1

SELECT SUM(amount) FROM table WHERE name = 'abc'; 

Answer 2

不知道有关MySQL，但 “标准” SQL将是：

select sum(amount) from yourTableName where name='abc' 

Answer 3

SELECT SUM(amount) AS total FROM table WHERE name = 'abc' 

Answer 4

SELECT name, SUM(amount) from Table GROUP BY name; 

Answer 5

SELECT SUM(amount) 
FROM tableName 
WHERE name='abc'