By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
with a(
ID_ORGAO_INTELIGENCIA
, ORD
, TEMREGIONAL
) as (
select 311,1,0 from dual union all
select 430,2,0 from dual union all
select 329,3,1 from dual union all
select 334,4,0 from dual union all
select 323,5,0 from dual union all
select 324,6,0 from dual union all
select 326,7,0 from dual
)
select
a.*
, coalesce(
lag(nullif(TEMREGIONAL, 0))
ignore nulls
over(order by ord asc)
, 0) as prev
from a
| ID_ORGAO_INTELIGENCIA | ORD | TEMREGIONAL | PREV |
|---|---|---|---|
| 311 | 1 | 0 | 0 |
| 430 | 2 | 0 | 0 |
| 329 | 3 | 1 | 0 |
| 334 | 4 | 0 | 1 |
| 323 | 5 | 0 | 1 |
| 324 | 6 | 0 | 1 |
| 326 | 7 | 0 | 1 |