mysql - 如果 Count<2 则不显示

Question

我正在尝试隐藏 Working_On 属性中的值，如果它们低于 2，我只是将它们显示出来。我曾尝试使用 WHERE 子句，但没有成功。我对 MySQL 很陌生。有人帮忙吗？

这是我正在使用的表格:

mysql> SELECT* 
       FROM employee_project;


+------+-------+---------------+
| eNum | pCode | date_assigned |
+------+-------+---------------+
| E246 | P123  | 2014-12-05    |
| E246 | P294  | 2013-11-21    |
| E387 | P123  | 2014-12-20    |
| E403 | P123  | 2015-04-15    |
| E403 | P332  | 2014-04-01    |
| E933 | P294  | 2013-11-21    |
| E933 | P332  | 2014-03-01    |
| E933 | P342  | 2014-12-20    |
+------+-------+---------------+



mysql> SELECT eNum, COUNT(pCOde) as Working_On 
       FROM employee_project 
       GROUP BY eNum;


    +------+------------+
    | eNum | Working_On |
    +------+------------+
    | E246 |          2 |
    | E387 |          1 |
    | E403 |          2 |
    | E933 |          3 |
    +------+------------+
    4 rows in set (0.00 sec)

Answer 1

下面的查询会帮到你

SELECT eNum, COUNT(pCOde) as Working_On 
   FROM employee_project 
   GROUP BY eNum;
   HAVING COUNT(pCOde) < 2;