mysql - 对从 COALESCE mySQL 查询的所有记录求和

Question

我有一个命令(如下)运行良好并返回大约 23 条记录。它从另一个表中获取类似记录的 int 数据，并为我总结每条记录。现在我想更进一步，将这 23 条记录减少为 1 条，这样我就能得到所有 23 条记录的总和。这可能吗？

SELECT COALESCE(SUM(d.Seconds),0)+a.Seconds AS Seconds
FROM table_One AS a
LEFT JOIN table_Two AS d ON d.ForeignKey = a.ID
GROUP BY a.ID

我想做这样的事情:

SELECT SUM(COALESCE(SUM(d.Seconds),0)+a.Seconds) AS Seconds

但这行不通。有什么想法吗？

Answer 1

你不需要两个SUM

   select sum(coalesce(d.Seconds, 0) + a.seconds) as seconds
    from table_One a
    LEFT JOIN table_Two d on d.ForeignKey = a.Id