中孚信息+味来科技

2019-05-31  本文已影响0人  wuhuaguo丶
 select *
   from (select tmp_tb.*, ROWNUM row_id
           from (select *
                   from (
                         select STARTTIME as starttime,
                                 CITY_NAME as cityName,
                                 DISTRICT_NAME as districtName,
                                 OPERATOR_NAME as operatorName,
                                 TECH as tech,
                                 GRID_ID as gridId,
                                 substr(GRID_ID, 0, 8) * 0.00001 as longitude,
                                 substr(GRID_ID, 10, 8) * 0.00001 as latitude,
                                 POOR_DT as poorDt,
                                 POOR_CQT as poorCqt,
                                 POOR_MR as poorMr,
                                 POOR_TS as poorTs,
                                 FLOW as flow,
                                 TRAFFIC as traffic,
                                 COMMON_DT as commonDt,
                                 COMMON_CQT as commonCqt,
                                 COMMON_TS as commonTs,
                                 COMMON_MR as commonMr,
                                 COMMON_TRAFFIC as commonTraffic,
                                 COMMON_FLOW as commonFlow,
                                 WEIGHT as weight
                           from ADS_TOWER_COMMON
                          where 1 = 1
                         )
                  where 1 = 1
                       
                    and starttime = '2019年1月'
                       
                    and cityName like '%枣庄市%'
                       
                    and operatorName like '%联通%'
                       
                    and tech like '%全部,4G%') tmp_tb
          where ROWNUM <= 25)
  where row_id > 0

上一篇 下一篇

猜你喜欢

热点阅读