求sql统计语句

[蜗蜗奶糖]

用asp怎么实现月统计与年统计？比如统计这个月的汇款，或当年的汇款！汇款时间和数额己经存在数据库中了！

[蜗蜗奶糖]

妈的，没分了，想删以前贴子，删不了了，大家快想想办法！

[windwl]

select sum(金额) where shijian between time1 and time2

[rockywu]

月统计与年统计??
select sum(金额) from table where time between begintime and endtime;
或者
select sum(金额) from table where time>=begintime and time<=endtime
表示时间范围!
下面查月
select sum(金额) from table where group by time having month(time)=month(searchtime)
查年
select sum(金额) from table where group by time having year(time)=year(searchtime)

[rockywu]

select sum(金额) from table group by time having month(time)=month(searchtime)
查年
select sum(金额) from table group by time having year(time)=year(searchtime)

[iasky]

select sum(cash) where time between a and b

a 到 b 时间内的

主要就是构造sql语句了

[tmxsl1214]

楼上两位有没有搞错，表名都没有。

select sum(金额) from table where time between begintime and endtime;

或者

select sum(金额) from table where time>=begintime and time<=endtime;