56,677
社区成员
发帖
与我相关
我的任务
分享
select *
from ERP_EMPLOYEE emp
where emp.DELETE_FLAG = '0'
and emp.emp_id in
( select DISTINCT emp_id from ERP_CERTIFICATE
where cert_end_date IS NOT NULL and cert_end_date != ''
and TIMESTAMPDIFF(MONTH,now(),cert_end_date) < 6
and DELETE_FLAG = '0')
order by (emp.EMP_ID + 0),CONVERT(emp.EMP_NAME USING GBK)NG GBK)
SELECT NOW(),SYSDATE(),SLEEP(2),NOW(),SYSDATE()