26_b10.sql 340 B

123456789101112131415161718
  1. --26、H端口实占率
  2. ---北10
  3. select
  4. smonth as MONTH_ID,
  5. '北10' as ZB_TYPE,
  6. sname as PROV_NAME,
  7. null as CITY_ID,
  8. null as CITY_NAME,
  9. null as GRID_ID,
  10. null as GRID_NAME,
  11. '26' as ZB_CODE,
  12. 'H端口实占率' as ZB_NAME,
  13. '是' as IS_RATIO,
  14. port_inuse as QZ_FZ,
  15. port_total as QZ_FM,
  16. port_rate as BY_QZ
  17. from sqmdb_cost.jt_number_b10
  18. where smonth='202206'