SELECT groupfield, SUM(somedata)
FROM tablename
GROUP BY groupfield

##</code><code>##

SELECT groupfield, MAX(somedata)
FROM tablename
GROUP BY groupfield