Oracle取交集

select t.experiment_process_record_id from bio_assay_value t where (t.assay_returntype_id=1 and t.value>20 and t.value<30) 

intersect

select t.experiment_process_record_id from bio_assay_value t where (t.assay_returntype_id=2 and t.value>50 and t.value<100)

感谢http://www.blogjava.net/rain1102/的友情帮助。