Comment by withinboredom

Sounds like a job for a windowing function.