select*fromisc_userwherenamecodelike'%qy.gd.csg.cn%' select*fromtmp_yx_user_0401 isc_usert.NAMECODE hr_user_qy0331_okLOGIN_NAMEisnotnull/*5334*/ select*fromtmp_yx_user_0401_qy_login_name; select*fromhr_user_qy0331_ok; CREATETABLEtmp_yx_user_qy_0403as( selecty.*,h.员工id,h.ouASHROU,h.员工所属

deletefrom资产佛山未对应上人员ok1where用户idin (select用户idfrom资产佛山未对应上人员ok1groupby用户idhavingcount(用户id)>1) androwidnotin(selectmin(rowid)from资产佛山未对应上人员ok1groupby用户idhavingcount(用户id)>1)

select*fromtmp_yx_user_0401_qy_okwherelogin_namein(selectlogin_namefromtmp_yx_user_0401_qy_okgroupbylogin_namehavingcount(login_name)>1)androwidnotin(selectmin(rowid)fromtmp_yx_user_0401_qy_okgroupbylogin_namehavingcount(login_name)>1)