Qq'un peut m'expliquer ca :
select isin, dte, volume,
sum(volume) over(partition by isin) volume_total,
sum(volume) over(partition by isin order by dte) volume_cumule
from COTATION
where isin = 'FR0000130007'
order by isin, dte
ISIN DTE VOLUME VOLUME_TOTAL VOLUME_CUMULE
-------------------- -------- ---------- ------------ -------------
FR0000130007 02/01/02 4155397 9941158109 4155397
FR0000130007 03/01/02 9266945 9941158109 13422342
FR0000130007 04/01/02 10741659 9941158109 24164001
FR0000130007 07/01/02 8462352 9941158109 32626353
FR0000130007 08/01/02 11571103 9941158109 44197456
FR0000130007 09/01/02 9459922 9941158109 53657378
FR0000130007 10/01/02 9175396 9941158109 62832774
VOLUME_TOTAL je pige pas