Re: problem with max date

max(RVYRMO) = 201303

therefore, your results are correct

201303 A
201303 C
201303 D





From: "Smith, Mike" <Mike_Smith@xxxxxxxxxxxxxxxx>
To: "Midrange Systems Technical Discussion (midrange-l@xxxxxxxxxxxx)"
<midrange-l@xxxxxxxxxxxx>,
Date: 01/17/2013 01:57 PM
Subject: problem with max date
Sent by: midrange-l-bounces@xxxxxxxxxxxx



I have a scenario where I need to pick this record with the highest YR/MO
from a file.
Records are like this

RVYRMO SCHED
201301 A
201301 B
201301 C
201301 D
201303 A
201303 C
201303 D

My query doesn't pick up the record

201301 B

My query looks like this

SELECT RVYRMO , SCHED,
FROM savectl00 where RVYRMO = (select max(RVYRMO) from savectl00 )

My results are

201303 A
201303 C
201303 D


My searching seems to indicate this is how to do it, but I'm not having
any luck.

What am I doing wrong?

Thanks

Mike

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.