Исходный код вики Группировка с условием на всю группу | Group by Having
Версия 2.1 от Alexandr Fokin на 2020/09/10 13:52
Скрыть последних авторов
author | version | line-number | content |
---|---|---|---|
![]() |
2.1 | 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}} |