RE: SQL Question

Hi,

Try out the below SQL statement to get the max of RVEHKY

SELECT DISTINCT RVEHNO, RVEHKY FROM QMFILES.GA560AP WHERE RVEHKY =
(SELECT max(RVEHKY) from QMFILES.GA560AP)

Thanks

Kamal Kumar M C

-----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?