谓词推入一列

select  *
  from mk_task_info_10032 b,
       
       (SELECT s.task_id,
               s.chn_type,
               s.contact_flag,
               s.accept_flag,
               s.fail_reason,
               s.service_name,
               s.oper_date,
               s.note
          FROM (SELECT task_id,
                       chn_type,
                       contact_flag,
                       accept_flag,
                       fail_reason,
                       service_name,
                       oper_date,
                       note,
                       ROW_NUMBER() OVER(PARTITION BY task_id ORDER BY exec_id DESC) rm
                  FROM mk_taskexec_info_10032
                 WHERE 1 = 1
                   and task_class in ('88')) s