剔重的一个操作

    select NAME1
      from (select 
                   NAME1,
                   ROW_NUMBER()OVER( partition by NAME1 order by ORD ) RN
              from (select NAME1, 
                           1 ORD
                      from MID.ODS_CB_ORGAN_GRID_LW_MESH
                 union all
                    select NAME1, 
                           2 ORD
                      from MID.ODS_CB_ORGAN_GRID_LW_MESH_02)
           )
     where RN = 1
  group by NAME1
    having count(*) > 1;