SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
CREATE TABLE members ( id INT, cm_no VARCHAR(20), lab_no VARCHAR(20), corporate_id VARCHAR(20) ); INSERT into members (id,cm_no,lab_no,corporate_id) values (1,'100','10-10-2021','member_1'), (2,'450','09-10-2021','member_2'), (3,'200','01-10-2021','member_2'), (4,'100','03-09-2021','member_4'); with upper_query as ( select count(cm_no), cm_no from members group by cm_no having count(cm_no)>1 ) select * from members where cm_no in (select cm_no from upper_query)
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear