Группировка с условием на всю группу | GROUP BY HAVING
Версия 3.3 от Alexandr Fokin на 2021/05/08 11:56
https://stackoverflow.com/questions/32122777/group-by-having-at-least-one-of-each-item
SELECT
person_id
FROM MyTable
GROUP BY person_id
HAVING 3 = (
MAX(CASE pet WHEN 'dog' THEN 1 ELSE 0 END)
+ MAX(CASE pet WHEN 'cat' THEN 1 ELSE 0 END)
+ MAX(CASE pet WHEN 'tiger ' THEN 1 ELSE 0 END)
)