Re: Window function for get the last value to extend missing rows

[postmaster@xxxxxxxxxxx]

Am 12.05.23 um 13:04 schrieb Durumdara:
> [...]
>
> The LAG function seems to be ok, but how to handle if more than two periods
> are missing?
>
> 03:00     10
> 03:01     NULL
> 03:02     NULL
> 03:03     NULL
> 03:04     11
> 03:05     13
>
> [...]
and how do you think about NULL in first(and second/third) row?