title: Combine Multiple Rows into One Row (One Column) when Using SQL
body: <p>How to combine multiple rows into one row:</p>
  
  <pre><code>Example:
  ID   NAME    NUMBER
  24   infill  20
  25   test1   10
  26   test2   30
  27   test5   35
  28   test3   40
  </code></pre>
  
  <p>
  
  <pre><code>SELECT 
        name,
        number 
  FROM table1 WHERE table1.id IN (24,26,28)
  </code></pre>
  
  <p>They will have result as:</p>
  
  <pre><code>NAME    NUMBER
  infill  20
  test2   30
  test3   40
  </code></pre>
  
  <p>How to modify SQL statement above: and I have one column name as I really want. </p>
  
  <p>Service </p>
  
  <pre><code>infill 20,test2 30, test3 40
  </code></pre>
  
  <p>I did: </p>
  
  <pre><code>select name + " " + number as Service 
  from table1
  where table1.id in (24,26,28)
  </code></pre>
  
  <p>Result is NULL, thank you all for reply my question.</p>