Re: SQL Question

[Mike <koldark@xxxxxxxxx>]

Thanks, this works perfectly.

On 5/16/07, Bob Elliott <belliott@xxxxxxxxxxxxxxxxxxx> wrote:
> How about:
>
> Select RVEHNO, MAX(RVEHKY) from qmfiles.ga560ap
> Group by rvehno
>
> Bob Elliott
> Sr Programmer
> City of Winchester
> 15 North Cameron St
> Winchester, VA 22601
> Phone: (540)-667-1815 ext 1462
> Fax (540)-722-3618
>
>
>
> -----Original Message-----
> From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx]
> On Behalf Of Mike
> Sent: Wednesday, May 16, 2007 2:14 PM
> To: RPG programming on the AS400 / iSeries
> Subject: SQL Question
>
> It's been a long day and I can't think. I have this SQL statement:
>
> SELECT DISTINCT RVEHNO, RVEHKY FROM QMFILES.GA560AP
> ORDER BY RVEHNO, RVEHKY DESC
>
> With a result of:
> RVEHNO    RVEHKY
> 0    0
> 1    685
> 1    339
> 2    703
> 3    16
> 4    470
> 4    17
> 5    18
> 6    19
> 7    20
> 8    21
> 9    22
>
> I only want the result with the highest RVEHKY. Ideas?
>
> --
> Mike Wills
> http://www.linkedin.com/in/mikewills
> Blog - http://mikewills.name
> Podcasts - http://podcastmike.com
> --
> This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.
>
> --
> This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.