SELECT e.Name, r.Score
FROM Employee e
JOIN EvaluationRecord r ON e.EmployeeID = r.EmployeeID
WHERE r.EvaluationDate BETWEEN ‘2023-01-01’ AND ‘2023-12-31’;
利唐i人事HR社区,发布者:HR数字化研究员,转转请注明出处:https://www.ihr360.com/hrnews/20241239993.html
SELECT e.Name, r.Score
FROM Employee e
JOIN EvaluationRecord r ON e.EmployeeID = r.EmployeeID
WHERE r.EvaluationDate BETWEEN ‘2023-01-01’ AND ‘2023-12-31’;
利唐i人事HR社区,发布者:HR数字化研究员,转转请注明出处:https://www.ihr360.com/hrnews/20241239993.html