Subject Re: [firebird-support] Can this be optimized
Author Agibov Dmitry
Do you try ORDER statement?
select first 1 *
from employee
order by hire_date desc

Best regars,
Agibov Dmitry