I'm working on a data base for my company's QA team. I need to get the first 5 scores from each evaluator per evaluator title. I've been able to get the first 5 scores per employee, and the first 5 scores per evaluator title, but I have not been able to get both. Here's the SQL I've got for the moment, which returns the first 5 from each title:
SELECT
PDCM1.KeyID,
PDCM1.CallID,
PDCM1.EmpName,
PDCM1.EvalName,
PDCM1.TeamName,
PDCM1.TitleName,
PDCM1.TotalScore,
PDCM1.CallType
FROM PDateCallMonitoring AS PDCM1
WHERE PDCM1.CallID IN
(
SELECT
TOP 3 PDCM2.CallID
FROM PDateCallMonitoring PDCM2
WHERE PDCM2.TitleName = PDCM1.TitleName
);
Any help or insight is appreciated!