34,593
社区成员
发帖
与我相关
我的任务
分享
declare @t table(fgysbm varchar(10),fsj datetime,fcpbm varchar(20),fdj numeric(5,2),fsl int)
insert into @t select '001','2008-05-02','010101',0.12,126
insert into @t select '001','2008-05-03','010101',0.11,212
insert into @t select '001','2008-05-04','010101',0.10,526
select fgysbm,fcpbm,
max(fdj) 最大单价,
min(fdj) 最小单价,
avg(fdj) 平均单价1,
sum(fdj*fsl)/sum(fsl)平均单价2,
(select top 1 fdj from @t where fgysbm = n.fgysbm and fcpbm = n.fcpbm order by fsj desc) 最新单价,
max(fsl) 最大数量,
min(fsl) 最小数量,
(select top 1 fsl from @t where fgysbm = n.fgysbm and fcpbm = n.fcpbm order by fsj desc) 最新数量
from @t n
group by fgysbm,fcpbm