oracle可以多个字段同时in,可以减少查询的次数
select * from table
where (patient_id,visit_id) in (select ‘80870719’,’1′ from dual);
oracle可以多个字段同时in,可以减少查询的次数
select * from table
where (patient_id,visit_id) in (select ‘80870719’,’1′ from dual);
转载于:https://www.cnblogs.com/gaopengpy/p/6849177.html