1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32
| SQL> with t as (
select 1 as cle, 'W' as pays from dual union all
select 2 as cle, 'A' as pays from dual union all
select 3 as cle, 'D' as pays from dual union all
select 4 as cle, 'B' as pays from dual union all
select 5 as cle, 'V' as pays from dual union all
select 6 as cle, 'F' as pays from dual union all
select 7 as cle, 'Y' as pays from dual union all
select 8 as cle, 'U' as pays from dual union all
select 9 as cle, 'D' as pays from dual union all
select 10 as cle, 'L' as pays from dual
)
select cle, pays
, case when lead(pays) over(order by cle) in ('B','F') then 1 end as flag
from t; 2 3 4 5 6 7 8 9 10 11 12 13 14 15
CLE P FLAG
---------- - ----------
1 W
2 A
3 D 1
4 B
5 V 1
6 F
7 Y
8 U
9 D
10 L
10 ligne(s) selectionnee(s).
SQL> |
Partager