--每个人每天的。
select dd_kdzhanghao , convert(varchar(10),dd_kdshijian,120) [day] , count(*) ddshuliang
from dd
group by dd_kdzhanghao , convert(varchar(10),dd_kdshijian,120)--每个人某个固定日期的。
select dd_kdzhanghao , count(*) ddshuliang
from dd
where convert(varchar(10),dd_kdshijian,120) = '2008-12-11'
group by dd_kdzhanghao
select dd_kdzhanghao , convert(varchar(10),dd_kdshijian,120) [day] , count(*) ddshuliang
from dd
group by dd_kdzhanghao , convert(varchar(10),dd_kdshijian,120)--每个人某个固定日期的。
select dd_kdzhanghao , count(*) ddshuliang
from dd
where convert(varchar(10),dd_kdshijian,120) = '2008-12-11'
group by dd_kdzhanghao
from dd
where dd_kdshijian>'2008-12-11' and dd_kdshijian<'2008-12-12'
group by dd_kdzhanghao
sql如下:
select dd_kdzhanghao '开单人', convert(varchar(10),dd_kdshijian,120) '开单日期' , count(*) '开单数量'
from dd
group by dd_kdzhanghao , convert(varchar(10),dd_kdshijian,120)