mysql - SUM(MAX( ) + MAX( )) 怎么做？

Question

SUM(MAX() + MAX()) 有正确的方法吗？

这是我一直在努力做的事情

SELECT 
  SUM(MAX(account.BALANCE1) + MAX(account.BALANCE2)) AS TOTALBALANCE
FROM
  account
      JOIN
  transaction t ON account.PRIMARYKEY = t.ACCOUNTKEY
WHERE
  NOT EXISTS( SELECT 
          1
      FROM
          transaction a
      WHERE
          a.ACCOUNTKEY = t.ACCOUNTKEY
              AND a.TYPE = 'PAYMENT')
HAVING TOTALBALANCE > 0

内容如下:

Error Code: 1111. Invalid use of group function

Answer 1

由于您没有指定任何 GROUP BY 子句，

MAX(account.BALANCE1) + MAX(account.BALANCE2)

应该足以满足您的需求。