关联表数据去重查询， row_number() over(partition by

select * from (


select cb.town_branch_no,
       cb.prov_branch_name,
       cb.city_branch_name,
       cb.town_branch_name,
       si.t00salesno,
       si.t01name,
       row_number() over(partition by cb.town_branch_no order by cb.town_branch_no) as rn
  from spi_info si
  left join c_Branch cb
    on si.town_branch_no = cb.town_branch_no
 where si.t00salesno not in (select sf.salesno from SIGN_FACE_TIME sf)
   and si.t01probationdate >= to_date('2018-01-01', 'yyyy-mm-dd') ) where rn = 1