mysql - MySQL 中函数 'count(*)' 返回的限制(截止)数

Question

这个问题已经有答案了:

Unknown Column In Where Clause (16 个回答)

已关闭 5 年前。

当我在 MySQL 中尝试这个时:

select make,count(*) as num from TABLE where num > 100 group by make

我得到:

Error Code: 1054, SQL State: 42S22]  Unknown column 'num' in 'where clause'

有没有办法限制count(*)？

Answer 1

您不能将列别名放在 WHERE 子句中。使用派生表代替:

select make, num
from
(
    select make,count(*) as num from TABLE  group by make
) dt
where num > 100