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 100Please advise