SELECT * FROM Test_table WHERE 종류 IN (SELECT 종류 FROM Test_table GROUP BY 종류 HAVING MIN(이름_1) = 'AB' AND MIN(이름_2) = 'C' ) ;
SELECT t3.* FROM Test_table t1 INNER JOIN Test_table t2 ON t1.종류 = t2.종류 INNER JOIN Test_table t3 ON t2.종류 = t3.종류 WHERE t1.이름_1 = 'AB' AND t2.이름_2 = 'C' ;
SELECT * FROM Test_table m WHERE EXISTS (SELECT 1 FROM Test_table s WHERE s.종류 = m.종류 AND s.이름_1 = 'AB') AND EXISTS (SELECT 1 FROM Test_table s WHERE s.종류 = m.종류 AND s.이름_2 = 'C') ;
SELECT * FROM Test_table WHERE 종류 IN (SELECT 종류 FROM Test_table WHERE 이름 IN ('AB', 'C') GROUP BY 종류 HAVING COUNT(*) = 2 ) ;
SELECT t3.* FROM Test_table t1 INNER JOIN Test_table t2 ON t1.종류 = t2.종류 INNER JOIN Test_table t3 ON t2.종류 = t3.종류 WHERE t1.이름 = 'AB' AND t2.이름 = 'C' ;
SELECT * FROM Test_table m WHERE m.이름 IN ('AB', 'C') AND EXISTS (SELECT 1 FROM Test_table s WHERE s.종류 = m.종류 AND s.이름 <> m.이름 AND s.이름 IN ('AB', 'C') ) ;
SELECT * FROM Test_table m WHERE EXISTS (SELECT 1 FROM Test_table s WHERE s.종류 = m.종류 AND s.이름 = 'AB') AND EXISTS (SELECT 1 FROM Test_table s WHERE s.종류 = m.종류 AND s.이름 = 'C') ;