'Count': Counts the number of non-null values. 'Count(*)�

The Difference between 'Count' and 'Count(*)'

Question Posted / guest

Answer Posted / guest

'Count': Counts the number of non-null values.
'Count(*)': Counts the number of rows in the table,
including null values and duplicates.

Is This Answer Correct ?

42 Yes

2 No

Please Help Members By Posting Answers For Below Questions

Is a null value equal to anything? Can a space in a column be considered a null value? Why or why not?

841

What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?

2083

How can you check the version of sql server?

840

Can we join two tables without primary key?

842

What are some examples of schemas?

759

What is the server name in sql server?

758

Where to find ntwdblib.dll version 2000.80.194.0?

779

What are user-defined functions (udfs) in sql server?

770

Why we use trigger in sql server with example?

745

Explain DBCC?

772

A trigger can reference objects outside the current database? State true or false.

787

What is mssql?

756

How to create percentile function?

124

What is the data type of time?

731

How to start sql server browser service?

839