title: Get the column name based on it's value in row in SQL
body: <p>My table looks like this:</p>
  
  <pre><code>ID  Col1    Col2    Col3
  A   0   1   0
  B   1   0   1
  C   1   0   1
  </code></pre>
  
  <p>I want the name of the columns where value is 1 , the results should look like this:</p>
  
  <pre><code>ID  ColName     
  A   Col2        
  B   Col1,Col3       
  C   Col1,Col2       
  </code></pre>
  
  <p>Please advice on how can I get the results.
  Thanks!</p>