Версия 3.1 от Alexandr Fokin на 2020/09/18 20:35
Последние авторы
1
2 https://stackoverflow.com/questions/32122777/group-by-having-at-least-one-of-each-item
3
4 {{code language="sql"}}
5
6 SELECT
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}}