oracle nvl,having的用法

            select oi.order_id,opl.payment_no,opl.back_no, oi.commit_time, oi.receive_mobile, oi.receive_user,
              nvl((select s.code_id
                     from double_pay_check d, sys_code s
                    where d.is_delete = 'N'
                      and d.process_status = s.code_id
                      and d.order_id = oi.order_id),
                   (select s.code_id
                      from sys_code s
                     where s.code_type_no = 'double_pay_process_state'
                       and s.code_no = 'unprocess')) as process_status
              from order_payment_log opl,
                   order_info oi,
                   (select business_id
                      from (select l.business_id, l.payment_type_id, count(1)
                              from order_payment_log l
                             where l.paid_state = 'Y'
                               and l.is_delete = 'N'
                               and l.business_type = 'order'
                             group by l.business_id, l.payment_type_id
                            having count(1) > 1)) t
             where opl.business_id = t.business_id
               and oi.ORDER_ID = opl.business_id
               and oi.is_delete = 'N'
               and opl.business_type = 'order'
               and opl.paid_state = 'Y'
               and opl.is_delete = 'N'
    

 

转载于:https://www.cnblogs.com/wangchuanfu/p/8108823.html