| 12345678910111213141516171819 |
- --12、单端口网运成本（月）
- ---网格
- select
- smonth as MONTH_ID,
- '网格' as ZB_TYPE,
- '河北' as PROV_NAME,
- city_code*100 as CITY_ID,
- city_name as CITY_NAME,
- grid_code as GRID_ID,
- grid_name as GRID_NAME,
- '12' as ZB_CODE,
- '单端口网运成本（月）' as ZB_NAME,
- '否' as IS_RATIO,
- cost_total as QZ_FZ,
- ftth_port_sts_count as QZ_FM,
- cost_port as BY_QZ
- from sqmdb_cost.rpt_dport_cost_grid
- where smonth='202206'
- order by city_code
|
