select * from per_all_people_f papf where trunc(sysdate) between trunc(papf.effective_start_date) and trunc(papf.effective_end_date) and papf.employee_number = 145;
posted on 2014-12-09 18:41 rigidwang 阅读(223) 评论(0) 编辑 收藏 举报