--显示所有的数据
select * from dayproduct
union
--显示统计数据(截止今天)
select convert(varchar(10),getdate(),120) as 日期,
产品名称,数量=(select sum(数量) from dayproduct b
where b.日期>=DATEADD(mm, DATEDIFF(mm,0,getdate()), 0)
--当月第一天
and b.日期<=convert(varchar(10),getdate(),120)
and a.产品名称=b.产品名称)
from dayproduct a
select * from dayproduct
union
--显示统计数据(截止今天)
select convert(varchar(10),getdate(),120) as 日期,
产品名称,数量=(select sum(数量) from dayproduct b
where b.日期>=DATEADD(mm, DATEDIFF(mm,0,getdate()), 0)
--当月第一天
and b.日期<=convert(varchar(10),getdate(),120)
and a.产品名称=b.产品名称)
from dayproduct a
select *,
月累计产量=( select sum(日产量)
from dayproduct
where 产品名称='金'
and 时间 between '2004-5-1' and '2004-5-14'
)
from dayproduct
where 产品名称='金' and 时间 = '2004-5-13'