Thanks for the advice. My query is a little more controlled than the cases exposed in the article.

I use an equal join and only >= inside the same ID, which...

It's good to know about LAG and LEAD, that I didn't know of, but I use the approach below when faced with that kind of problem and don't have performance...