title: How to select one column from multiple columns returning from a select statement in mysql
body: <p>I want to select just one column from multiple columns in a select statement. </p>
  
  <pre><code>select 
      A, sum(B) paid
  from
     T
  where
      K LIKE '2015%'
  group by A
  having B &gt;= 100
  </code></pre>
  
  <p>This query will return two columns but how to select just the first column from the select query? If I do something like this :</p>
  
  <pre><code>select A from (select 
      A, sum(B) paid
  from
     T
  where
      K LIKE '2015%'
  group by A
  having B &gt;= 100 ) 
  </code></pre>
  
  <p>It is running into errors? Is there a way in mysql to select the only the first column ? </p>