title: Select max value of each group
body: <pre><code>Name    Value   AnotherColumn
  -----------
  Pump 1  8000.0  Something1
  Pump 1  10000.0 Something2
  Pump 1  10000.0 Something3
  Pump 2  3043    Something4
  Pump 2  4594    Something5
  Pump 2  6165    Something6
  </code></pre>
  
  <p>My table looks something like this. I would like to know how to select max value for each pump.</p>
  
  <pre><code>select a.name, value from out_pumptable as a,
  (select name, max(value) as value from out_pumptable where group by posnumber)g where and g.value = value
  </code></pre>
  
  <p>this code does the job, but i get two entries of Pump 1 since it has two entries with same value.</p>