使用反证法
select *
from ma_model_task t
where t.id not in
(
select m.id
from ma_model_task m
where (m.first_date <
to_date('2018-08-07 00:00:00', 'yyyy-mm-dd hh24:mi:ss') and
m.last_date <
to_date('2018-08-10 23:59:59', 'yyyy-mm-dd hh24:mi:ss'))
or (m.first_date >
to_date('2018-08-07 00:00:00', 'yyyy-mm-dd hh24:mi:ss') and
m.last_date >
to_date('2018-08-10 23:59:59', 'yyyy-mm-dd hh24:mi:ss'))
)