Исходный код вики Группировка с условием на всю группу | GROUP BY HAVING
Версия 3.1 от Alexandr Fokin на 2020/09/18 20:35
Последние авторы
| author | version | line-number | content |
|---|---|---|---|
| 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}} |