Re: SQL Question

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.