1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
| with matable as (select to_date('06/06/17', 'DD/MM/RR') datemaj, 'A067' IDPR, 42 valeur FROM DUAL
union all select to_date('06/06/17', 'DD/MM/RR') datemaj, 'A070' IDPR, 95.2 valeur FROM DUAL
union all select to_date('11/02/11', 'DD/MM/RR') datemaj, 'A091' IDPR, 45 valeur FROM DUAL
union all select to_date('06/06/17', 'DD/MM/RR') datemaj, 'A091' IDPR, 1337 valeur FROM DUAL
union all select to_date('11/02/11', 'DD/MM/RR') datemaj, 'A092' IDPR, 45 valeur FROM DUAL
union all select to_date('06/06/17', 'DD/MM/RR') datemaj, 'A092' IDPR, 33.6 valeur FROM DUAL
union all select to_date('11/02/11', 'DD/MM/RR') datemaj, 'A093' IDPR, 45 valeur FROM DUAL
union all select to_date('06/06/17', 'DD/MM/RR') datemaj, 'A093' IDPR, 33.6 valeur FROM DUAL
union all select to_date('11/02/11', 'DD/MM/RR') datemaj, 'A094' IDPR, 45 valeur FROM DUAL
union all select to_date('11/02/11', 'DD/MM/RR') datemaj, 'A095' IDPR, 45 valeur FROM DUAL
union all select to_date('06/06/17', 'DD/MM/RR') datemaj, 'A095' IDPR, 56 valeur FROM DUAL
)
select idPR, datemaj, valeur, NVL((lead(datemaj, 1) over (partition by idpr order by datemaj)) - 1, TRUNC(SYSDATE)+1) Fin
from matable
order by idPR, datemaj |
Partager