How to check group for containing certain elements in SQL? -
i have simple table:
id num 1 7 1 5 1 4 2 5 2 4 2 7 3 4 3 7
how select ids having num 5 7 , 4
for example ids: 1, 2
select `id` `table` `num` in (4, 5, 7) group `id` having count(*) = 3
Comments
Post a Comment