You can do this without window function also in FB<3, but less efective. Do
simple 2 subselects in your select.
Regards,
Karol Bieniaszewski
On 04/03/2019 15:56, Karol Bieniaszewski liviusliv...@poczta.onet.pl
[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 ...
--
Les
>>Can you explain how?
I do not study your topic much and i can be wrong here. But maybe you got the
idea about what i am thinking about.
SELECT
(SELECT
PRE.ITEM_CONTENT_ID
FROM
FISHEYE_GALLERY_IMAGE_MAP PRE
WHERE
PRE.GALLER