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.员工所属

selectc.*,fn_getpy(c_name)||'@'|| (casewhennewoulike'%潮州%'then'cz.gd.csg.cn'when newoulike'%东莞%'then'dg.gd.csg.cn'whennewoulike'%佛山%'then'fs.gd.csg.cn'when newoulike'%河源%'then'hy.gd.csg.cn'whennewoulike'%惠州%'then'hz.gd.csg.cn'when newoulike'%江门%'then'jm.gd.csg.cn'whennewoulike'%揭阳%'then'jy.gd

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)

/*updatehr_user_qy0331_oklsetl.login_name_new=substr(l.login_name,1,instr(l.login_name,'@')-1)||to_char(to_date(l.从身份证号码截取出生日期,'yyyy/mm/dd'),'mmdd')||substr(l.login_name,instr(l.login_name,'@'))wherel.从身份证号码截取出生日期isnotnullandl.同名否='same'andl.login_nameisnotnul