SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
CREATE TABLE tbl ( Man_reg VARCHAR(255), Man_type int ); INSERT INTO tbl VALUES ('Moscow', 1), ('Moscow', 2),('Moscow', 3), ('Kazan', 1), ('Ekaterinburg', 2); SELECT * FROM tbl; SELECT Man_reg FROM tbl GROUP BY Man_reg HAVING GROUP_CONCAT(DISTINCT Man_type ORDER BY Man_type ASC) = '1,2,3';
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear