title: How to concatenate many rows with same id in sql?
body: <p>My table contains the details like with two fields:</p>
  
  <pre><code>ID      DisplayName
  1        Editor
  1        Reviewer
  7        EIC
  7        Editor
  7        Reviewer
  7        Editor
  19       EIC
  19       Editor
  19       Reviewer
  </code></pre>
  
  <p>I want get the unique details with DisplayName like</p>
  
  <p><code>1 Editor,Reviewer 7 EIC,Editor,Reviewer</code></p>
  
  <p>Don't get duplicate value with ID 7</p>
  
  <p>How to combine DisplayName Details? How to write the Query?</p>