mysql - 如何从mysql中的select语句返回的多列中选择一列

Question

我想在 select 语句中从多列中只选择一列。

select 
    A, sum(B) paid
from
   T
where
    K LIKE '2015%'
group by A
having B >= 100

此查询将返回两列，但如何从选择查询中只选择第一列？如果我这样做:

select A from (select 
    A, sum(B) paid
from
   T
where
    K LIKE '2015%'
group by A
having B >= 100 ) 

它遇到错误了吗？ mysql 中有没有办法只选择第一列？

Answer 1

您的第二个查询是正确的，只是您没有在 b

之前添加 sum

试试这个

select A from (select 
    A, sum(B) paid
from
   T
where
    K LIKE '2015%'
group by A
having sum(B) >= 100 ) As temp