select
MinStringFieldValue, MaxStringFieldValue
from
WageConstantIntervals
where
(Parent_ID = :Parent_ID) and
ValidFrom$DATE in
(
select max(ValidFrom$DATE) from WageConstantIntervals
where
(Parent_ID = :Parent_ID) and
(ValidFrom$DATE <= :ValidFrom)
)Generated by ABRA Software a.s. 27.10.2021 16:34:36