资源描述:
《e-hr系统sql查询语句(e-hr system sql query statement)》由会员上传分享,免费在线阅读,更多相关内容在教育资源-天天文库。
1、e-hr系统sql查询语句(E-HRSystemSQLquerystatement)ThecurrentstatusisregularemployeeC_EMPLOYEESTATUS=2Inaccordancewiththestaffnumberfromsmalltolargeorderorderbyc_codeASCBrushdegreesawardedtothestateasemptySelect,C_DEGREECOUNTRY,e.*,edu.rowid,from,tb_inf_empeducation,edu,tb_inf_employee,eWhereedu.c_degreeisno
2、tnullandedu.C_DEGREECOUNTRYisnullande.c_employeeid=edu.c_empoidande.c_knowledgein('1_1','1_2','1_3','1_4','1_5','2_1','2_2','2_3','2_4','2_5','2_6','2_7','2_8','4_1','4_2','4_3')AndC_EMPLOYEESTATUS=2BrushyourmajorfornothingSelect,edu.C_SPECIALITY,e.*,edu.rowid,from,tb_inf_empeducation,edu,tb_inf_emp
3、loyee,eWhereedu.c_gradein(select,empedu.c_grade,from,tb_inf_empeducation,empedu,where,empedu.c_grade,like,'1_%',or,empedu.c_grade,like,'2_%')and,edu.C_SPECIALITY,is,,nullAnd,e.c_employeeid=edu.c_empoid,and,e.c_knowledge,in('1_1','1_2','1_3','1_4','1_5','2_1','2_2','2_3','2_4','2_5','4_3','2_6','2_7'
4、,'2_8','4_1','4_2',c)And,C_EMPLOYEESTATUS=2,and,e.C_SPECIALTY,is,not,nullRetrieveemployeenumberandchangeeducationalinformationSelect,edu.*,edu.rowid,from,tb_inf_empeducation,edu,tb_inf_employee,eWhere,e.c_employeeid=edu.c_empoid,and,e.c_knowledge,in('1_1','1_2','1_3','1_4','1_5','2_1','2_2','2_3','2
5、_4','2_5','4_3','2_6','2_7','2_8','4_1','4_2',c)Andc_code=011600015708Retrieveemployeenumber,askstafftoworktimeandageSelectc_beginworkdatefromtb_inf_employeeWherec_code=011600015708Formalstaffeducation,degree,professionalquerystatement(accordingtoemployeenumberfromsmalltolargeorder)Select,c_code,c_n
6、ame,c_knowledge,c_degree,c_specialty,from,tb_inf_employeeWhereC_EMPLOYEESTATUS=2Orderbyc_codeASCThetechnicalpersonnel'soccupationnameisemptySelect,c_code,c_name,C_JOB_NAME,e.rowid,from,tb_inf_employee,eWhere,e.c_postfamily,in(`auxiliaryproductionoperations','serviceclassoperations','directproduction
7、post'),and,e.C_JOB_NAME,is,nullAndC_EMPLOYEESTATUS=2Orderbyc_codeASCOfficialstaffpositionquerySelect,c_code,c_name,e.C_POSTFAMILY,from,tb_inf_employee,eWhereC_EMPLOYEESTATUS=2Jobdispatchpersonnelapply