它不包含在聚合函数或GROUP by子句中。 [英] It is not contained in either an aggregate function or the GROUP by clause.

问题描述

plz帮助，查询给我总计函数的错误



我尝试过：



SELECT Date_Created，SUM（Total_Amount）FROM dbo.FinalBillGenerated YEAR（Date_Created）= 2016 group by YEAR（Date_Created），Month（Date_Created）

plz help, query gives me error of aggregate function

What I have tried:

SELECT Date_Created, SUM(Total_Amount) FROM dbo.FinalBillGenerated where YEAR(Date_Created)= 2016 group by YEAR(Date_Created),Month(Date_Created)

推荐答案

您选择的项目必须是聚合（例如SUM（Total_Amount））或必须包含在group by子句中。



Date_Created！= YEAR （Date_Created）或Month（Date_Created）

Your Selected items must either be aggregates ( "SUM(Total_Amount)" for eg) or must be contained in the group by clause.

Date_Created != YEAR(Date_Created) or Month(Date_Created)

SELECT 
    YEAR(Date_Created), 
    Month(Date_Created),
    SUM(Total_Amount) 
FROM 
    dbo.FinalBillGenerated 
where 
    YEAR(Date_Created)= 2016 
group by 
    YEAR(Date_Created),
    Month(Date_Created)

这篇关于它不包含在聚合函数或GROUP by子句中。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！