select * from percentage
model return updated rows
partition by (policy)
dimension by (priority p)
measures ( 1 q , percentage pc)
rules (
    q[p] = NVL(q[cv()-1] + (1-q[cv()-1]) * pc[cv()],pc[cv()])
)
;

会给你带来

55188   1   0,3     0,3
55188   2   0,65    0,5
55166   1   0,65    0,65
55166   2   0,811   0,46
55166   3   0,8488  0,2

可以使用解析函数来选择优先级为每个策略的最大值的行。

select policy, p, q from (
    select row_number() over(partition by policy order by p desc) as rn, policy, p, q from (
        select policy, p, q from percentage
        model return updated rows
        partition by (policy)
        dimension by (priority p)
        measures ( 1 q , percentage pc)
        rules (
            q[p] = NVL(q[cv()-1] + (1-q[cv()-1]) * pc[cv()],pc[cv()])
        )
    ) d
)
where rn = 1
;