首页 >数据库 >mysql教程 >MySQL中在含有GROUP BY的SELECT语句中显示COUNT()为0的结果_MySQL

MySQL中在含有GROUP BY的SELECT语句中显示COUNT()为0的结果_MySQL

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB原创
2016-06-01 13:30:271707浏览

bitsCN.com

MySQL中在含有GROUP BY的SELECT语句中显示COUNT()为0的结果

 

mysql> select * from t1;+-------+------+| level | name |+-------+------+|     1 | a    ||     1 | b    ||     1 | c    ||     2 | a    ||     2 | b    ||     4 | a    ||     5 | b    |+-------+------+7 rows in set (0.00 sec)mysql> select * from t2;+------+| id   |+------+|    1 ||    2 ||    3 ||    4 ||    5 |+------+5 rows in set (0.02 sec)mysql> select t2.id as level,count(case when name is not null then 1 end) as count    ->   from t2 left join t1 on t2.id = t1.level    -> group by t2.id;+-------+-------+| level | count |+-------+-------+|     1 |     3 ||     2 |     2 ||     3 |     0 ||     4 |     1 ||     5 |     1 |+-------+-------+5 rows in set (0.00 sec)

 

 

bitsCN.com
声明:
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系admin@php.cn