title: GROUP BY one field, keeping other fields
body: <p>Base table <code>bod</code> with three fields:</p>
  
  <pre><code>| BOFORM_ID | FEINBOD | MAECHTBOD | 
  +-----------+---------+-----------+
  |   3301211 | fSms    |        50 |
  |   3301211 | mSfs    |       150 |
  |   3301231 | fSms    |       200 |
  |   3301312 | Ss      |       150 |
  |   3301312 | Su2     |        50 |
  </code></pre>
  
  <p>I'd like to </p>
  
  <ol>
  <li><p>Group by <code>BOFORM_ID</code> </p></li>
  <li><p>get the maximum value from <code>MAECHTBOD</code></p></li>
  <li><p>while keeping the associated <code>FEINBOD</code> from the same row as the maximum of <code>MAECHTBOD</code>. </p></li>
  </ol>
  
  <p>I don't know how to implement step 3.</p>
  
  <p>My desired output: </p>
  
  <pre><code>| BOFORM_ID | FEINBOD | MAECHTBOD | 
  +-----------+---------+-----------+
  |   3301211 | mSfs    |       150 |
  |   3301231 | fSms    |       200 |
  |   3301312 | Ss      |       150 |
  </code></pre>