title: select one row per ID
body: <p>I have following table: </p>
  
  <pre><code>180555  &lt;id&gt;404&lt;/id&gt;    Meetjesland 404 2067    314
  180555  &lt;id&gt;404&lt;/id&gt;    Aalter      405 2067    404
  504684  &lt;id&gt;2104&lt;/id&gt;   Ballonvaart 723 2067    722
  504684  &lt;id&gt;778&lt;/id&gt;    Activiteit  1086 2067   313
  </code></pre>
  
  <p>I need to group this by ID (left column)
  so it should look like this</p>
  
  <pre><code>180555  &lt;id&gt;404&lt;/id&gt;    Meetjesland 404 2067    314
  504684  &lt;id&gt;2104&lt;/id&gt;   Ballonvaart 723 2067    722
  </code></pre>
  
  <p>I mean, the second, third,... row with the same ID doesn't give any more information so it shouldn't showed in fact. I can't do dintinct because there are columns that have different values..</p>
  
  <p>Thanks for any help</p>