declare @t datetime
set @t='2004-05-02 23:59:59'
select convert(varchar(10),getdate(),120)+'日销售',数量=(select sum(数量) from 销售记录 where datediff(day,日期,@t)=0)
union select
select '至'+convert(varchar(10),getdate(),120)+'销售',数量=(select sum(数量) from 销售记录 where 日期<=@t)
set @t='2004-05-02 23:59:59'
select convert(varchar(10),getdate(),120)+'日销售',数量=(select sum(数量) from 销售记录 where datediff(day,日期,@t)=0)
union select
select '至'+convert(varchar(10),getdate(),120)+'销售',数量=(select sum(数量) from 销售记录 where 日期<=@t)
select 商品编号,sum(case when 日期>='2004-5-2' and 日期<'2004-5-3' then 数量 else 0 end) as [2销售量],
sum(数量) as 累计销售量
from 销售记录
where 日期<getdate()
group by 商品编号--结果商品编号 2销售量 累计销售量
----------- ---------------------------------------- ----------------------------------------
1001 5.00 12.00
1002 58.00 116.00
1003 31.00 62.00(所影响的行数为 3 行)
declare @t datetime
set @t='2004-05-02 23:59:59'
select convert(varchar(10),@t,120)+'日销售',数量=(select sum(数量) from 销售记录 where datediff(day,日期,@t)=0)
union
select '至'+convert(varchar(10),@t,120)+'销售',数量=(select sum(数量) from 销售记录 where datediff(day,@t,日期)<=0)