一,根据从表生成主表数据
insert into map_base_tower
(id,tower_id,type,bs_name,autoname,gps_lng,gps_lat,bd_lng,bd_lat,hx_lng,hx_lat,province,area,county,sgrid,bak1,status)
select id,tower_id,'hh',bs_name,autoname,gps_lng,gps_lat,bd_lng,bd_lat,hx_lng,hx_lat,province,area,county,sgrid,reg_addr,'1'
from (select row_number() over(partition by tower_id order by id) my_rank,
id,tower_id,lac_ci,bs_name,autoname,lac,cellid,gps_lng,gps_lat,bd_lng,bd_lat,hx_lng,hx_lat,province,area,county,sgrid,reg_addr
from map_base_cell
where gps_lng is not null
and gps_lat is not null)
where my_rank = 1