在 sum 函数上无效使用 group 函数 [英] Invalid use of group function on sum function

问题描述

我的 SQL 查询返回错误 #1111 - 对结果中的行求和时无效使用组函数

My SQL query is returning an error #1111 - Invalid use of group function when summing the rows on result

此查询工作正常并返回多行.

This Query is working fine and returning many rows.

SELECT credit.Amount - SUM( COALESCE( creditreceived.Amount, 0 ) ) AS 
AmountReceivable FROM credit LEFT JOIN creditreceived ON credit.ID = 
creditreceived.CreditID WHERE credit.CompanyID =  '1' GROUP BY credit.id

结果图像:http://oi65.tinypic.com/qplyli.jpg

我想对这些行求和，为此我使用了这个查询

I want to sum these rows, to do so I am using this query

SELECT SUM( credit.Amount - SUM( COALESCE( creditreceived.Amount, 0 ) ) ) AS
AmountReceivable FROM credit LEFT JOIN creditreceived ON credit.ID = 
creditreceived.CreditID WHERE credit.CompanyID =  '1' GROUP BY credit.id

这是返回错误#1111 - 组函数的使用无效

推荐答案

觉得不是group by的问题.试试

It think the problem is not the group by. Try

SUM( credit.Amount - COALESCE( creditreceived.Amount, 0 ) ) AS..

这篇关于在 sum 函数上无效使用 group 函数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！