Z zdwwf Unregistered / Unconfirmed GUEST, unregistred user! 2004-03-02 #2 SELECT sum(数值) AS S FROM 表 GROUP BY Int((Month(Date)-1)/3)
B blyb Unregistered / Unconfirmed GUEST, unregistred user! 2004-03-02 #3 最好在表中增加一个季度字段,录入数据时根据Date字段的值判断它属于那个字段,汇总时:SELECT SUN(汇总字段) FROM 表名 GROUP BY 季度字段