select
cgicode,destccode from fobvtdestupric
where
( ( vtexcetodate is null and vtexcedate<=TO_DATE('9/1/2016','mm/dd/yyyy') ) or ( vtexcedate<=TO_DATE('9/1/2016','mm/dd/yyyy') and vtexcetodate > TO_DATE('9/1/2016','mm/dd/yyyy')) )
and status='70'
where
( ( vtexcetodate is null and vtexcedate<=TO_DATE('10/1/2016','mm/dd/yyyy') ) or ( vtexcedate<=TO_DATE('10/1/2016','mm/dd/yyyy') and vtexcetodate >TO_DATE('10/1/2016','mm/dd/yyyy')) )
where
( ( vtexcetodate is null and vtexcedate<=TO_DATE('9/1/2016','mm/dd/yyyy') ) or ( vtexcedate<=TO_DATE('9/1/2016','mm/dd/yyyy') and vtexcetodate > TO_DATE('9/1/2016','mm/dd/yyyy')) )
and status='70'
minus
where
( ( vtexcetodate is null and vtexcedate<=TO_DATE('10/1/2016','mm/dd/yyyy') ) or ( vtexcedate<=TO_DATE('10/1/2016','mm/dd/yyyy') and vtexcetodate >TO_DATE('10/1/2016','mm/dd/yyyy')) )
and status='70'
找到截止日不是下一条开始日的数据。