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)
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值