首页select Sum(PowerInverter) PowerInverter,SUM(ThisPower) ThisPower from (select a.id,thisPower,PowerInverter,ROW_NUMBER() over( partition by EquipmentId order by RecordTime desc) as new_index from Inverter_History A left join Equipment_Info b on a.EquipmentId = b.id left join Equipment_Type c on b.EquipmentTypeId = c.Id and c.TypeName='逆变器' where b.EnterpriseId='B4C8F629-0703-4C83-8978-E955F63EB058') A WHERE new_index=1

select Sum(PowerInverter) PowerInverter,SUM(ThisPower) ThisPower from (select a.id,thisPower,PowerInverter,ROW_NUMBER() over( partition by EquipmentId order by RecordTime desc) as new_index from Inverter_History A left join Equipment_Info b on a.EquipmentId = b.id left join Equipment_Type c on b.EquipmentTypeId = c.Id and c.TypeName='逆变器' where b.EnterpriseId='B4C8F629-0703-4C83-8978-E955F63EB058') A WHERE new_index=1

时间: 2024-04-01 17:38:21 浏览: 35

这是一个 SQL 查询语句，目的是查询企业ID为B4C8F629-0703-4C83-8978-E955F63EB058的所有逆变器的功率逆变器和当前功率的总和。查询语句中使用了子查询和窗口函数，先将逆变器历史数据和设备信息、设备类型信息进行关联，筛选出逆变器设备并按照记录时间降序排序，再使用窗口函数获取每个设备的最新记录，最后对查询结果进行汇总求和。

阅读全文