"SQL: copying data up"

Post #303027267 by figaro on Wednesday 12th of December 2018 03:19:15 PM

Full Discussion: SQL: copying data up
Old 12-12-2018
This is what I have come up with in the meantime:
select * 
from (select events.*, case when in_event then @delta := level else @delta end delta from events, (select @delta := 0) e order by date) delta
order by date desc;