the table's primary key is on acnum,accode and txndt
i need to display the dates which are closest
to the current date (sysdate)
ie. in case of acnum 0001 the record where txndt is
5/1/2003 should be shown (the 3/1/2003 dated one should not be returned)
similarly for acnum of 0796 the 9/5/2003 record should be returned.
any idea on how i can get this ? your help would be greatly appreciated.