一个关于sum 的问题

[a791223]

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的话就起不到合计的作用了呀，请大家帮助。

[pengdali]

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,2003 as fcdate ,'2003-8-20 18:31:44','上海','郑州'

from fctj where year(fcdate)=2003 and month(fcdate)=7 and fcdhgs='苏州' and fcfhgs='上海'

[caiyunxia]

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='上海'
group by year(fcdate),

[a791223]

to: pengdali(大力 V2.0)
2003 as fcdate 这个是什么意思。
to:caiyunxia(monkey)
这个group by year(fcdate)如果这样用的话那就没有办法合计了。

[pengdali]

select '常量' as 别名 from 表

或：

select '常量' 别名 from 表

[w_jie]

我的理解楼上大力的意思。看了你的语句感觉你是要统计2003年的一些字段的sum,所以就直接用 2003 as fcdate来作为fcdate字段值，来取代你原来的year(fcdate)

[pengdali]

y

[w_jie]

嘻嘻，还好理解正确*^Q^*.

[a791223]

我的意思是要取出fcdate 这个日期型字段中的年份和月份，组成后插入到新的表中。