Select Gpauniq, Suniq, Cumgpa ; FROM gpahist g1 ; WHERE Str(Gpauniq) + Str(Suniq) IN ( ; SELECT Str(Max(Gpauniq)) + Str(Suniq) ; FROM gpahist ; GROUP BY Suniq)>
* Using correlated query >Select Gpauniq, Suniq, Cumgpa ; > FROM gpahist g1 ; > WHERE Str(Gpauniq) + Str(Suniq) IN ( ; > SELECT Str(Max(Gpauniq)) + Str(Suniq) ; > FROM gpahist g2 WHERE g2.Suniq = g1.Suniq) >* If it's slow you can try to split it into two queries >SELECT Max(Gpauniq) As Gpauniq, Suniq ; > FROM gpahist g2 ; > GROUP BY Suniq ; > INTO CURSOR crsMaxGpauniq >Select g1.Gpauniq, g1.Suniq, g1.Cumgpa ; > FROM gpahist g1 ; > JOIN crsMaxGpauniq m1 ; > ON g1.Gpauniq = m1.Gpauniq ; > AND g1.Suniq = m1.Suniq >>