2 ms·
Is the hiring task SELECT TOP 1 * FROM Candidates WHERE DIVERSE = 1 ORDER BY Candidate_Value_All_Things_Considered DESC or SELECT TOP 1 * FROM Candidates
by sokoloff 4y ago
Is the hiring task
SELECT TOP 1 * FROM Candidates WHERE DIVERSE = 1 ORDER BY Candidate_Value_All_Things_Considered DESC
or
SELECT TOP 1 * FROM Candidates ORDER BY Candidate_Value_All_Things_Considered DESC
There could be valid reasons to employ either strategy, but I suspect most firms are trying to apply the second and your disbelief that the first query returns zero rows is more a mismatch with the firms' hiring strategy than anything else.
- qaq 4y agoI am not suggesting they have to employee 1st or 2nd strategy. But if you do go with the 2nd don't go down the path of by-weekly employee diversity trainings and diversity being the corner stone of your "values" and communication strategy.
- sokoloff 4y agoIMO, diversity contributes to, but does not define (the high-order bit of) Candidate_Value_All_Things_Considered.