报表_5_电费单价.sql 405 B

1234567891011121314151617
  1. --5 转供电超高电费单价站点
  2. select distinct
  3. city_sname as city_name,
  4. build_name as jz_name,
  5. station_type as jz_type,
  6. station_level as cj,
  7. property_type as qs_type,
  8. eprice as df_dj,
  9. cost_unit_name as bc_zx,
  10. city_code as city_id,
  11. smonth as month_id,
  12. grid_code as county_id,
  13. area_name as county_name,
  14. sort_id_city
  15. from sqmdb_cost.rpt_baobiao_5_cgdf
  16. where smonth='202205'
  17. order by sort_id_city,station_level