Welcome, guest! Login / Register - Why register?
Psst.. new poll here.
[email protected] webmail now available. Want one? Go here.
Cannot use outlook/hotmail/live here to register as they blocking our mail servers. #microsoftdeez


Pasted as SQL by registered user vvillacorta ( 2 years ago )
SELECT periodo, num_ruc,
       max(flg_desembolso) flg_desembolso,
       max(CASE WHEN order_tasa = 1 and flg_desembolso = 1 then tasa_desembolsada
                WHEN order_tasa = 1 and flg_desembolso = 0 then tasa_piso
                ELSE NULL END
        ) tasa_final
    select *,
           row_number() over (
                partition by periodo, num_ruc order by 
                (case when flg_desembolso = 1 and tasa_desembolsada is not null then 0
                           else tasa_piso end
                ) asc
          ) order_tasa
GROUP BY periodo, num_ruc


Revise this Paste

Your Name: Code Language: