Re: %%How to <efficiently> do: SELECT MAX(Date)...WHERE Date < myParamDate

declare

   cursor cu_max_rate is
   select rating
   from rating
   order by rdate desc;

   max_rate number;
begin

   open cu_max_rate;

   fetch cu_max_rate
   into max_rate;

   close cu_max_rate;
end;

-- 

William WW LEE.
E-Mail: william_at_alumni.cuhk.edu.hk
***********************************