id num addtime
1 1 2009-5-10
2 5 2009-5-15
3 2 2009-6-11
4 2 2009-6-21按月份统计sum(num)
select sum(num) as strnum from TABLE group by month(addtime)
结果:
6
4但是我需要在asp rs 中使用addtime 做为if 条件,addtime就要出现在 select中,而且要按照month(addtime)分组,
这样的话,group by 子句要怎么写
sql语法才正确呢~
也就是select sum(num) as strnum,ADDTIME from TABLE group by .......... ?谢谢哇,在线
1 1 2009-5-10
2 5 2009-5-15
3 2 2009-6-11
4 2 2009-6-21按月份统计sum(num)
select sum(num) as strnum from TABLE group by month(addtime)
结果:
6
4但是我需要在asp rs 中使用addtime 做为if 条件,addtime就要出现在 select中,而且要按照month(addtime)分组,
这样的话,group by 子句要怎么写
sql语法才正确呢~
也就是select sum(num) as strnum,ADDTIME from TABLE group by .......... ?谢谢哇,在线
from tb
group by convert(varchar(7),addtime,120)
TABLE1 group by CONVERT(VARCHAR(7),ADDTIME,120)
from tb
group by convert(char(7),addtime,120)
select sum(num) as num,convert(varchar(7),addtime,120) as addtime
from tb
group by convert(varchar(7),addtime,120)
from table
group by convert(varchar(7),addtime,120)
select convert(varchar(7),addtime,120) as addtime,sum(num) as num from tb
group by convert(varchar(7),addtime,120)