Questions Linux Laravel Mysql Ubuntu Git Menu

HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin

In SQL is there a difference between count(*) and count(<fieldname>)

Tags:

sql

Pretty self explanatory question. Is there any reason to use one or the other?

like image

435

asked Jan 11 '09 22:01

Spencer Ruport

2 Answers

Count(*) counts all records, including nulls, whereas Count(fieldname) does not include nulls.

like image

146

answered Oct 03 '22 22:10

Fionnuala

Select count(*) selects any row, select count(field) selects rows where this field is not null.

like image

22

answered Oct 03 '22 22:10

Otávio Décio

Sign in to Comment

Related questions
                            
                                SQL date format convert? [dd.mm.yy to YYYY-MM-DD]
                            
                                sql select records that don't have relation in a second table
                            
                                Why is a UDF so much slower than a subquery?
                            
                                Select query in pymysql
                            
                                SQL: Insert all records from one table to another table without specific the columns
                            
                                TSQL: How to get a list of groups that a user belongs to in Active Directory
                            
                                How can i check to see if my sqlite table has data in it?
                            
                                Is it safe to install SQL Server 2008 R2 and MySQL side-by-side on Windows Server 2003 Enterprise Edition?
                            
                                How to check whether a SQL query is successful with C#
                            
                                How to md5 all columns regardless of type
                            
                                how to get current/Todays date data in sql server
                            
                                Pros and cons of connecting more than one database in single script
                            
                                Oracle empty conditions to check the ' ' condition
                            
                                Query giving division by zero error in PostgreSQL
                            
                                Compare only day and month with date field in mysql
                            
                                SQL server: can't save/change table design
                            
                                Surprising SQL speed increase
                            
                                To find infinite recursive loop in CTE
                            
                                Database independence through JDBC in java
                            
                                Oracle database is hanging infinitly in UPDATE queries

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!

Donate Us With