On 04/03/2019 15:56, Karol Bieniaszewski liviuslivius@...
[firebird-support] wrote:

> You can do this without window function also in FB<3, but less efective.
> Do simple 2 subselects in your select.

Can you explain how?
Without the full window scan LAG and LEAD gave NULL ...

--
Lester Caine - G8HFL
-----------------------------
Contact - https://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - https://lsces.co.uk
EnquirySolve - https://enquirysolve.com/
Model Engineers Digital Workshop - https://medw.co.uk
Rainbow Digital Media - https://rainbowdigitalmedia.co.uk