SQL get max per id
snippet in sql

SQL get max per id

user6980

select name, max(value)
from out_pumptable
group by name