数据库:某个字段为空,分组查询后COUNT计数

原始表:SELECT * FROM student
image

分组查询的结果:SELECT * FROM student GROUP BY name
image

COUNT计数结果:SELECT COUNT(1) FROM student GROUP BY name
image

可以看到字段为空,计数都是算上所有

posted @ 2022-04-04 15:38  捷后愚生  阅读(205)  评论(0编辑  收藏  举报