Re: As On A Date query

Hi,

You could create a B*tree index on (ac_no,XXXXdate) and try something like: select balance from t where ac_no=101 and XXXXdate=(select max(XXXXdate) from t where ac_no=101 and XXXXdate<='10-APR-2005');

Jerome

-- 
Message posted via http://www.dbmonster.com