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)"
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

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

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?



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.

Return to Archive home page | Return to MIDRANGE.COM home page