MYSQL如何求和两个连接的字段

Question

您好，您知道如何对两个定义的字段求和吗？这可能吗？

SELECT SUM(a) as total_a, SUM(b) as total_b, (total_a + total_b) as grand_total
FROM table

如果没有，我怎么能想出这个？

Answer 1

您也可以像这样内联:

SELECT SUM(a) as total_a, SUM(b) as total_b, (sum(a) + sum(b)) as grand_total
FROM table