使用集合的概念:
select test_id from tab_test
where (test_name,test_desc) =(zsg1,tttt1)
intersect
select test_id from tab_test
where (test_name,test_desc) =(zsg2,tttt2)
minus
select test_id from tab_test
where (test_name,test_desc) =(zsg3,tttt3)
select test_id from tab_test
where (test_name,test_desc) =(zsg1,tttt1)
intersect
select test_id from tab_test
where (test_name,test_desc) =(zsg2,tttt2)
minus
select test_id from tab_test
where (test_name,test_desc) =(zsg3,tttt3)
select test_id from tab_test
where (test_id in (select testid from table_test where test_name='zsq1' and test_desc='tttt1')and test_id in(select testid from table_test where test_name='zsq2' and test_desc='tttt2'))