title: MySQL: Show all rows with same column value one after the other with the column value appearing only once
body: <p>I have a table with columns: </p>
  
  <pre><code>ResourceId | Reason
  </code></pre>
  
  <p>I have 4 rows with values as follows </p>
  
  <pre><code>2884 | irrelevant
  3441 | irrelevant
  2884 | incorrect
  1234 | incorrect
  </code></pre>
  
  <p>I want the data to appear something like this:-</p>
  
  <pre><code>2884 | irrelevant
       | incorrect
  3441 | irrelevant
  1234 | incorrect
  </code></pre>
  
  <p>i.e. I want all the rows with similar ResourceId to appear together as a group but I only want to display the ResourceId for the first row. How can I write a query for this?</p>