I have a scenario where I need to pick this record with the highest YR/MO from a file.
Records are like this
My query doesn't pick up the record
My query looks like this
SELECT RVYRMO , SCHED,
FROM savectl00 where RVYRMO = (select max(RVYRMO) from savectl00 )
My results are
My searching seems to indicate this is how to do it, but I'm not having any luck.
What am I doing wrong?
NOTICE: This message, including any attachment, is intended as a confidential and privileged communication. If you have received this message in error, or are not the named recipient(s), please immediately notify the sender and delete this message.