Returns the maximum value of a field
SELECT StageName, MAX(Amount) FROM Opportunity GROUP BY StageName