弹性考勤记录查询SQL如何筛选特定员工的记录？

1天前 • HR动态, 产品 • 阅读 8

弹性考勤记录查询sql

    SELECT ar.*, e.employee_name, d.department_name
    FROM attendance_records ar
    JOIN employees e ON ar.employee_id = e.employee_id
    JOIN departments d ON e.department_id = d.department_id
    WHERE e.employee_status = '在职'
    AND d.department_name = '研发部'
    AND ar.record_date BETWEEN '2024-01-01' AND '2024-01-31';

利唐i人事HR社区，发布者：ihreditor，转转请注明出处：https://www.ihr360.com/hrnews/20241224218.html

考勤记录