count - It returns the non null values count(*)

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

Question Posted / rajeeva tripathi

Answer Posted / rajeeva tripathi

count - It returns the non null values
count(*) - It returns the null values and duplicate values

Is This Answer Correct ?

3 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What do you understand by mirroring?

951

What are different types of raid configurations? : SQL Server Architecture

1003

What is the difference between join and inner join?

952

What are sql dirty pages?

969

What is the current pricing model of SQL Azure?

104

What is the syntax to execute the sys.dm_db_missing_index_details?

966

what is the difference between Tabular and Matrix report?

160

Can you explain what is the use of custom fields in report?

1000

How to set database to be single_user in ms sql server?

967

How many levels of sp nesting is possible?

996

Explain transaction isolation levels in sql server?

1035

How to receive output values from stored procedures?

1054

What is the difference between count and distinct count?

842

what are the Prerequisites for Replication?

11241

How to replace given values with null using nullif()?

924