Select max value of each group December 17, 2022 by Tarik select name, max(value) from out_pumptable group by name