Find the next non-NULL row in a series with SQL
Here is another SQL special from jOOQ inventor Lukas Eder. Looking at a time series of data points where certain events happen, there are several issues that can occur. Here’s how you can deal with those problems.