SQLize Online / PHPize Online  /  SQLtest Online

create table Test (id bigserial, num int); insert into Test (num) values (1); insert into Test (num) values (2); insert into Test (num) values (5); insert into Test (num) values (5); insert into Test (num) values (4); insert into Test (num) values (4); insert into Test (num) values (4); insert into Test (num) values (5); insert into Test (num) values (22); insert into Test (num) values (55); insert into Test (num) values (55); insert into Test (num) values (55); insert into Test (num) values (55); insert into Test (num) values (34); insert into Test (num) values (34); insert into Test (num) values (34); SELECT num FROM Test GROUP BY num HAVING COUNT(num) = 3;