--SQL Server 2005
With CTE_T(dwm,neijing,liuliang,danjia,heji)
as
(
select dwm,neijing,liuliang,danjia,sum(liuliang * danjia)as heji From liuliang where left(riqi,4)='2006' and shi ='烟台市' group by dwm,neijing,liuliang,danjia
)
select dwm,liuliang=sum(liuliang) from CTE_T
group by dwm
With CTE_T(dwm,neijing,liuliang,danjia,heji)
as
(
select dwm,neijing,liuliang,danjia,sum(liuliang * danjia)as heji From liuliang where left(riqi,4)='2006' and shi ='烟台市' group by dwm,neijing,liuliang,danjia
)
select dwm,liuliang=sum(liuliang) from CTE_T
group by dwm
select dwn,sum(liuliang) from (select dwm,neijing,liuliang,danjia,sum(liuliang * danjia)as heji From liuliang where left(riqi,4)='2006' and shi ='烟台市' group by dwm,neijing,liuliang,danjia ) group by dwn
select t1.*,t2.heji
from liuliang t1,
(select dwn,sum(liuliang * danjia)as heji From liuliang group by dwn)
where t1.dwn = t2.dwn
shi,qu,neijing也相同吗?要不贴点数据出来~
sum(liuliang * danjia)as heji,
liuliang的和=(select sum(liuliang) from liuliang where dwn=a.dwn)
From liuliang a
where datepart(year,riqi)='2006' and shi ='烟台市' group by dwm,neijing,liuliang,danjia
我原来的语句在执行的时候,会显示很多相同的DWM的记录,我想在原来的语句基础上改造,把相同的DWM的liuliang相加求和,求高手赐教