title: select max value within grouped ids
body: <p>I have a table with the values</p>
  
  <pre><code>ID  RefID value
  1    1       0
  2    1       200
  3    2       300
  4    3       100
  5    3        0
  </code></pre>
  
  <p>I need the result like below</p>
  
  <pre><code>ID  RefID value
  1    1       200
  2    1       200
  3    2       300
  4    3       100
  5    3       100
  </code></pre>
  
  <p>Thanks in advance,</p>