Версия 3.9 от Alexandr Fokin на 2022/01/03 14:54

Скрыть последних авторов
Alexandr Fokin 2.1 1
2 https://stackoverflow.com/questions/32122777/group-by-having-at-least-one-of-each-item
3
4 {{code language="sql"}}
5
Alexandr Fokin 3.1 6 SELECT
Alexandr Fokin 2.1 7 person_id
8 FROM MyTable
9 GROUP BY person_id
10 HAVING 3 = (
11 MAX(CASE pet WHEN 'dog' THEN 1 ELSE 0 END)
12 + MAX(CASE pet WHEN 'cat' THEN 1 ELSE 0 END)
13 + MAX(CASE pet WHEN 'tiger ' THEN 1 ELSE 0 END)
14 )
15
16 {{/code}}