title: applying concat function on one column values to get data from another table
body: <p>table :</p>
  
  <pre><code>value  
  - v1  
  - v2
  </code></pre>
  
  <p>Now , I need to apply concat function on value col</p>
  
  <pre class="lang-sql prettyprint-override"><code>concat(v1 , ' ' , v2) 
  </code></pre>
  
  <p>like this.</p>
  
  <p>I have used <code>concat()</code> on two or more col values but not on rows of one column.</p>
  
  <p>How should I do it?</p>