check_03_tieta.sql 307 B

12345678910111213
  1. --铁塔--输出报表
  2. select
  3. smonth as 月份,
  4. city_operator as 地市名称,
  5. area_operator as 区县名称,
  6. site_addr_id as 铁塔站址编码,
  7. station_sid as 局站id,
  8. station_sname as 局站名称,
  9. property_type as 产权类型,
  10. station_level as 局站等级,
  11. stype as 铁塔校验
  12. from sqmdb_cost.err_has_tw_no_station
  13. order by sort_id_city