Oracle的组合条件查询

组合条件查询,以下两种方式都可以:
select b.job_id,
b.source,
b.create_via,
b.who_create,
b.location_code,
b.ref_no
from (select rownum r, a.*
from (select j.*, cj.location_code, cj.ref_no
from nfs_gbl.combine_job j, nfs_gbl.combine_job_criteria cj
where j.status = 0
and j.job_id = cj.job_id
and ((trim(cj.location_code) || trim(cj.ref_no) != 'A0ADWHBATCH091501')
or (trim(cj.location_code) || trim(cj.ref_no) != 'A0ADWHBATCH091502'))
order by j.job_id) a) b
where r < 2;


select b.job_id,
b.source,
b.create_via,
b.who_create,
b.location_code,
b.ref_no
from (select rownum r, a.*
from (select j.*, cj.location_code, cj.ref_no
from nfs_gbl.combine_job j, nfs_gbl.combine_job_criteria cj
where j.status = 0
and j.job_id = cj.job_id
and (cj.location_code, cj.ref_no) not in
(select cjc.location_code, cjc.ref_no
from nfs_gbl.combine_job_criteria cjc
where ((cjc.location_code = 'A0AD' and
cjc.ref_no = 'WHBATCH091501') or
(cjc.ref_no = 'WHBATCH091502' and
cjc.location_code = 'A0AD')))
order by j.job_id) a) b
where r < 2;
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值