Исходный код вики Группировка с условием на всю группу | GROUP BY HAVING

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

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}}

Приложения