向大家请教一个按每天做统计的SQL问题~！

[facepp]

向大家请教一个按每天做统计的SQL问题~！
假如表是这样的

G_ID vtime shu
1 2006-8-9 8:22:09 100
2 2006-8-9 8:22:09 100
3 2006-8-10 8:22:09 100
4 2006-8-10 8:22:09 100

我想最终页面这样显示


9日 200
10日 200

[playwarcraft]

group by day(vtime)
======================
不過建議用這個
group by convert(char(10),vtime,120)

[昵称被占用了]

select 
day(vtime) as 日期,
sum(shu) as shu
from tab
where vtime>='2006-8-1' and vtime<'2006-9-1'
group by day(vtime)

[昵称被占用了]

建议不要跨月查询

[dawugui]

不同月份也这么算?

[viva369]

select
day(vtime),
sum(shu)
from tab
group by day(vtime)

[dawugui]

[Quote=引用楼主 facepp 的帖子:]
向大家请教一个按每天做统计的SQL问题~！
假如表是这样的

G_ID vtime shu
1 2006-8-9 8:22:09 100
2 2006-8-9 8:22:09 100
3 2006-8-10 8:22:09 100
4 2006-8-10 8:22:09 100

我想最终页面这样显示


9日 200
10日 200
[/Quote]

我觉得还是按年月日的好.

select convert(varchar(10),vtime,120) ymd , sum(shu) shu from tb group by convert(varchar(10)

[-狙击手-]

select
datepart(d,vtime) as 日期,
sum(shu) as shu
from tab
group by datepart(d,vtime)

[areswang]

create table tb(g_id int,vtime datetime,shu int)
go
insert into tb select 1,'2006-8-9 8:22:09',100
union all
select 2,'2006-8-9 8:22:09',100
union all
select 3,'2006-8-10 8:22:09',100
union all
select 4,'2006-8-10 8:22:09',100

select DATENAME(DAY,vtime)+'日',sum(shu) from tb group by vtime
---------------------
9日 200
10日 200