title: Can we use Select query output as Column alias
body: <p>i need a select statements output as a columns's alias </p>
  
  <p>is it possible</p>
  
  <p>examples</p>
  
  <pre><code>select columnname as (select value from tablename)  from tablename
  </code></pre>
  
  <p>output</p>
  
  <p>values</p>
  
  <p>1</p>
  
  <p>2</p>
  
  <p>3</p>