它不包含在聚合函数或GROUP by子句中。 [英] It is not contained in either an aggregate function or the GROUP by clause.
本文介绍了它不包含在聚合函数或GROUP by子句中。的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
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屋!
查看全文