SQL LIST OF MAXIMUM ENTRIES PER GROUP code example Example: SQL get max per id select name, max(value) from out_pumptable group by name