总结select count(*)、count(1)、count(0)区别
效果:三者的返回结果是一样的。
意义:当count的参数是具体值时(如count(0)、count(1)、count('a')、count(100)),count的参数已没有实际意义了。
范围:在统计范围,count(*)和count(1) 和count(0)一样,都包括对NULL的统计(因为oracle伪列rowid不会为NULL);count(column) 是不包括NULL的统计。
速度:相差不大,count(*),自动会优化指定到那一个字段。所以没必要去count(1),用count(*),sql会帮你完成优化的
![](http://img.blog.itpub.net/blog/attachment/201708/9/30126024_1502271750cHnc.jpg?x-oss-process=style/bb)
![](http://img.blog.itpub.net/blog/attachment/201512/29/30126024_145135745201vh.png?x-oss-process=style/bb)
![](http://img.blog.itpub.net/blog/attachment/201512/29/30126024_1451357452fVrd.png?x-oss-process=style/bb)
![](http://img.blog.itpub.net/blog/attachment/201512/29/30126024_14513574533ESo.png?x-oss-process=style/bb)
![](http://img.blog.itpub.net/blog/attachment/201512/29/30126024_1451357453OOYl.png?x-oss-process=style/bb)
![](http://img.blog.itpub.net/blog/attachment/201512/29/30126024_145135745371Ob.png?x-oss-process=style/bb)
![](http://img.blog.itpub.net/blog/attachment/201512/29/30126024_1451357454k7z9.png?x-oss-process=style/bb)
![](http://img.blog.itpub.net/blog/attachment/201512/29/30126024_14513574541ze0.png?x-oss-process=style/bb)
![](http://img.blog.itpub.net/blog/attachment/201512/29/30126024_14513574554Ow1.png?x-oss-process=style/bb)
![](http://img.blog.itpub.net/blog/attachment/201512/29/30126024_14513574552mSL.png?x-oss-process=style/bb)
![](http://img.blog.itpub.net/blog/attachment/201512/29/30126024_14513574556ESE.png?x-oss-process=style/bb)
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/30126024/viewspace-1966440/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/30126024/viewspace-1966440/