数据库:某个字段为空,分组查询后COUNT计数
原始表:SELECT * FROM student

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

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

可以看到字段为空,计数都是算上所有
原始表:SELECT * FROM student

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

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

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