Help for this page

Select Code to Download

Select or download this

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

Select or download this

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