title: SQL Query to split 1 value into 3 rows
body: <p>My requirement is like. I have 3 column &amp; 1 row.</p>
  
  <pre><code>Column A -&gt; Value a
  Column B -&gt; Value b
  Column C -&gt; Value 123
  </code></pre>
  
  <p>I have to split value in column C and get 3 rows from that, and also copy values from another columns. I have to get 3 rows and it should be like:</p>
  
  <pre><code>Column A -&gt; Value a , a , a
  Column B -&gt; Value b , b , b
  Column C -&gt; Value 1, 2, 3
  </code></pre>
  
  <p>Any Idea?</p>