group by 和字段同名的字符串

最新推荐文章于 2023-06-13 15:40:34 发布

原创最新推荐文章于 2023-06-13 15:40:34 发布 · 778 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#sql #groupby #分组 #数据库

此查询从多个表中联接数据，筛选2018年1月至7月间特定区域内的水能消耗记录，包括设备类型名称及能耗详情。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

SELECT a.id AS "id", a.node_id AS "nodeId", ifnull(a.energy_value, 0) AS "energyValue",
a.record_time AS "recordTime", a.create_by AS "createBy.id", a.create_date AS "createDate",
a.update_by AS "updateBy.id", a.update_date AS "updateDate", a.remarks AS "remarks",
a.del_flag AS "delFlag", a.energy_type_id AS "energyTypeId", a.area_name AS "areaName",
a.co2_id AS "coId", ifnull(a.unit_price, 0) AS "unitPrice", ifnull(a.total_price, 0) AS
"totalPrice", et.name AS "energyType", beti.equipment_type_name AS "equipTypeName" FROM
painuo_month_energy a , energy_type et, bi_equipmentbase_info bebi, bi_equipmenttype_info
beti WHERE a.del_flag = 0 and a.energy_type_id = et.id and et.name like concat('%','水','%')
and a.node_id = bebi.id and beti.id = bebi.type_id and a.record_time <= '2018-07' and
a.record_time >= '2018-01' group by 'a.record_time' ORDER BY a.area_name, a.record_time DESC

SELECT a.id AS "id", a.node_id AS "nodeId", ifnull(a.energy_value, 0) AS "energyValue",
a.record_time AS "recordTime", a.create_by AS "createBy.id", a.create_date AS "createDate",
a.update_by AS "updateBy.id", a.update_date AS "updateDate", a.remarks AS "remarks",
a.del_flag AS "delFlag", a.energy_type_id AS "energyTypeId", a.area_name AS "areaName",
a.co2_id AS "coId", ifnull(a.unit_price, 0) AS "unitPrice", ifnull(a.total_price, 0) AS
"totalPrice", et.name AS "energyType", beti.equipment_type_name AS "equipTypeName" FROM
painuo_month_energy a , energy_type et, bi_equipmentbase_info bebi, bi_equipmenttype_info
beti WHERE a.del_flag = 0 and a.energy_type_id = et.id and et.name like concat('%','水','%')
and a.node_id = bebi.id and beti.id = bebi.type_id and a.record_time <= '2018-07' and
a.record_time >= '2018-01' group by a.record_time ORDER BY a.area_name, a.record_time DESC