Hi,
I would like to get largest sales amount records for each day. I use the following SQL, it return correct largest sales amount field value, but always last salesno. Any ideas?

SELECT SalesNo, SalesDate, MAX(Amount) AS MaxAmount ;
FROM Sales ;
GROUP BY 1, 2 ;
INTO CURSOR csrMax

Data:
SalesNo     SalesDate         Amount
A00001      01/01/2003        100
A00002      01/01/2003        200
A00003      02/01/2003        100
A00004      01/01/2003        100

Expected Result:
A00002      01/01/2003        200
A00003      02/01/2003        100

Wrong Result returned by SQL above
A00004      01/01/2003        100
A00003      02/01/2003        100

Please advise