title: How to select only one field where id number is the same sql
body: <p>I have a table that is as follows</p>
  
  <pre><code>bugID  | name  | description  | comment
  ----------------------------------------------------------------
  1      | bug1  | first bug    | &lt;p&gt;&lt;/p&gt;
  1      | bug1  | first bug    | &lt;p&gt;this is the first bug&lt;/p&gt;
  1      | bug1  | first bug    | &lt;p&gt;this needs fixing&lt;/p&gt;
  2      | bug2  | second bug   | &lt;p&gt;this is the second bug&lt;/p&gt;
  3      | bug3  | third bug    | &lt;p&gt;bug number 3&lt;/p&gt;
  </code></pre>
  
  <p>I want to get the records back as follows if I do a select * from this table</p>
  
  <pre><code>1, bug1, first bug, &lt;p&gt;&lt;/p&gt;, &lt;p&gt;this is the first bug&lt;/p&gt;, &lt;p&gt;this needs fixing&lt;/p&gt;
  2, bug2, second bug, &lt;p&gt;this is the second bug&lt;/p&gt;
  3, bug3, third bug, &lt;p&gt;bug number 3&lt;/p&gt;
  </code></pre>
  
  <p>Is there a way I can do this in SQL?</p>