I can't figure out how to accomplish this.
I have a file that I want to update using SQL. I want to update ONLY the oldest record. The record contains a date and time field. However doing a select, returns multiple records matching my criteria. How can I update only the oldest record in one UPDATE statement?
Here's the select statement that returns multiple records.
select * from myFile
where chrcno = :myReceiver and chisbn = :myIsbn and chsts = 'RCV'
order by chrcvdt,chrcvtm