0

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!

dc-ddfe
  • 487
  • 1
  • 11
Ace_Q
  • 41
  • 6

0 Answers0