今天做项目时偶尔需要根据元素属性分类查询数据总和,故记录
select SUM(case when RIGHT(F_ModelNodeID,4)='1000' then F_Value else 0 end) as 照明用电,
SUM(case when RIGHT(F_ModelNodeID,4)='2000' then F_Value else 0 end) as 空调用电,SUM(case when RIGHT(F_ModelNodeID,4)='3000' then F_Value else 0 end) as 动力用电,
SUM(case when RIGHT(F_ModelNodeID,4)='4000' then F_Value else 0 end) as 特殊用电
from [TTBEMS_Exhibition].[dbo].[T_ME_ModelEnergyValue]
where convert(char(10),F_Time,120)=convert(char(10),getdate(),120)