select convert(varchar(10),时间字段,120) as 日期,sum(销售额) as 销售总额 from tb where convert(varchar(10),时间字段,120) between 'xx' and 'xx" group by convert(varchar(10),时间字段,120)
select convert(varchar(10),时间字段,120) as 日期,sum(销售额) as 销售总额 from tb where convert(varchar(10),时间字段,120) between 'xx' and 'xx' group by convert(varchar(10),时间字段,120)
select convert(varchar(10),日期,120) , sum(销售额) 销售总额 from tb where 日期 between '日期1' and '日期2' group by convert(varchar(10),日期,120)
--如果你的日期存在间断,需要先做个日期表,然后用left join,大致如下:select m.dt , isnull(n.销售总额,0) 销售总额 from ( select '2010-06-01' dt union all select '2010-06-01' dt union all select '2010-06-01' dt union all .... select '2010-06-30' dt ) m left join ( select convert(varchar(10),日期,120) dt, sum(销售额) 销售总额 from tb where 日期 between '日期1' and '日期2' group by convert(varchar(10),日期,120) ) n on m.dt = n.dt
convert(varchar(10),时间字段,120) as 日期,sum(销售额) as 销售总额
from
tb
where
convert(varchar(10),时间字段,120) between 'xx' and 'xx"
group by
convert(varchar(10),时间字段,120)
convert(varchar(10),时间字段,120) as 日期,sum(销售额) as 销售总额
from
tb
where
convert(varchar(10),时间字段,120) between 'xx' and 'xx'
group by
convert(varchar(10),时间字段,120)
select convert(varchar(10),日期,120) , sum(销售额) 销售总额
from tb
where 日期 between '日期1' and '日期2'
group by convert(varchar(10),日期,120)
(
select '2010-06-01' dt union all
select '2010-06-01' dt union all
select '2010-06-01' dt union all
....
select '2010-06-30' dt
) m left join
(
select convert(varchar(10),日期,120) dt, sum(销售额) 销售总额
from tb
where 日期 between '日期1' and '日期2'
group by convert(varchar(10),日期,120)
) n
on m.dt = n.dt