Re: Oracle LAG OVER en Mysql

[Stéphane Guyot]

Bonjour,

En fait en faisant un inner join j'ai réussi à faire ce que je voulais

select B.DAY as CURRENT_DAY, B.HLRID as CURRENT_HLRID, B.RANK as CURRENT_RANK ,
max(qGetPrev.DAY) as PREVIOUS_DAY,
max(qGetPrev.HLRID) as PREVIOUS_HLRID,
max(qGetPrev.RANK) as PREVIOUS_RANK
from OPM_DATA_DB.ALC_HLR_SUPSER_PEG_HH B
inner join
(
select HLRID, RANK, DAY
from OPM_DATA_DB.ALC_HLR_SUPSER_PEG_HH
) qGetPrev
on qGetPrev.HLRID = B.HLRID and qGetPrev.RANK = B.RANK
and qGetPrev.DAY < B.DAY
group by B.HLRID, B.RANK, B.DAY;