Find a Id that contains all mentioned values
You can use a HAVING clause to filter your GROUP BY result.

SELECT CategoryId
FROM ModeTester 
WHERE Mode IN ('H', 'W', 'R')
GROUP BY CategoryId
HAVING Count(CategoryId) = 3