报表_2_端口能耗.sql 388 B

12345678910111213141516
  1. --2 µ¥¶Ë¿ÚÄܺÄ
  2. select
  3. city_name as city_name,
  4. grid_name as wg_name,
  5. cost_port_nenghao as wg_dd_nh,
  6. cost_port_nenghao_city as bd_dd_nh,
  7. over_cost_city as bd_dwfd,
  8. rn_city as bd_pm,
  9. cost_port_nenghao_prov as qs_dd_nh,
  10. over_cost_prov as qs_fd,
  11. rn_prov as qs_pm,
  12. city_code as city_id,
  13. smonth as month_id
  14. from sqmdb_cost.rpt_baobiao_2_ddk
  15. where smonth='202205'
  16. order by sort_id_city,rn_city