Welcome To Ask or Share your Answers For Others

为啥下图答案给出的的子查询count(1)查询不用分组也是可以的

asked Jan 27, 2021 in Technique[技术] by 深蓝 (71.8m points)

查询每个部门的员工个数
二者的结果一样
图片.png

图片.png

图片.png

与恶龙缠斗过久,自身亦成为恶龙；凝视深渊过久,深渊将回以凝视…

3.5k views

Welcome To Ask or Share your Answers For Others

1 Answer

answered Jan 27, 2021 by 深蓝 (71.8m points)

关联子查询，子查询里边的where子句已经限定了id，此时id是唯一的，不需要group by。

与恶龙缠斗过久,自身亦成为恶龙；凝视深渊过久,深渊将回以凝视…

...