This article is tagged with:
Sql get max per id
and mysql
SQL get max per id
select name, max(value)
from out_pumptable
group by name