SELECT DISTINCT a.employee_code FROM employees e JOIN attendance a ON e.employee_code = a.employee_code WHERE a.attendance_date BETWEEN a.attendance_date AND DATE_ADD(a.attendance_date, INTERVAL 10 DAY) AND a.status IN ('请假', '缺席', '未标记') GROUP BY a.employee_code, a.attendance_date HAVING COUNT(*) = 11;
這個查詢找到在考勤記錄中有連續11天「請假」、「缺席」或「未標記」狀態的員工。它將員工資料與考勤資料連接起來，過濾特定的狀態和日期範圍，將資料分組，然後只選擇那些記錄數為11的群組。
SELECT DISTINCT a.employee_code FROM employees e JOIN attendance a ON e.employee_code = a.employee_code WHERE a.attendance_date BETWEEN a.attendance_date AND DATE_ADD(a.attendance_date, INTERVAL 10 DAY) AND a.status IN ('请假', '缺席', '未标记') GROUP BY a.employee_code, a.attendance_date HAVING COUNT(*) = 11;如果這個查詢對您不起作用，請分享您的模式。如果這個查詢有任何錯誤，請指出。