Re: null

Wed, 26 Apr 2006 20:06:29 -0700 

Hi Nikolay Trifonov !

Может так ? 

select coalesce((Select first 1 cr.Rate from Currency_Rate cr
     where cr.Date_change <= '26.04.2005'
       and cr.ID_Currency = 2
     order by cr.Date_change desc),0) from RDB$DATABASE


---------

Ответить