一个关于sum 的问题
select sum(fcneze) as i,sum(fcfhfq) as h,sum(fcdqgs) as g,sum(fcshdsef) as f,sum(fcpczsfe) as e,sum(fcfhzfzc) as d,sum(fcshzf) as c,year(fcdate),'2003-8-20 18:31:44','上海','郑州' from fctj where year(fcdate)=2003 and month(fcdate)=7 and fcdhgs='苏州' and fcfhgs='上海'
以上语句在运行时报
服务器: 消息 8118,级别 16,状态 1,行 1
列 'fctj.fcdate' 在选择列表中无效,因为该列未包含在聚合函数中,并且没有 GROUP BY 子句。
但是如果我用group by的话就起不到合计的作用了呀,请大家帮助。