(1)方法一:使用in方法。但是效率是十分慢的,不推荐使用。
获取表中order_id为00552010是否存在已经排序好的信息中
select hdoi.order_id from es_hybris_order hdoi where hdoi.order_id in
(SELECT resultr.order_id FROM (select hdo.order_id from es_hybris_order hdo
inner join es_third_party_order_reltn etpor on hdo.order_id = etpor.third_party_order_id
where hdo.VOUCHERS is not null order by hdo.order_id asc ) resultr where ROWNUM <= '22'
) and hdoi.order_id ='00552010';
(2)优化前方法。
发现其实还能去掉外面这一层。
select count(hdoi.order_id) from es_hybris_order hdoi where exis