RE: SQL Question

["Bob Elliott" <belliott@xxxxxxxxxxxxxxxxxxx>]

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?