Count(exp): Counts the number of rows excluding null values. Count(*) : Co

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

Question Posted / vijay dev saxena

Answer Posted / vijay dev saxena

Count(exp): Counts the number of rows excluding null values.
Count(*) : Counts the number of rows including null and
duplicates records.

Is This Answer Correct ?

13 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How many types of the database links?

1031

What is mean by clustered index and non clustered index, give syntax of creation? : sql server database administration

1047

What are the differences between char and nchar in ms sql server?

1024

If no size is defined while creating the database, what size will the database have?

935

What is a bit datatype?

932

What is the difference between for xml raw and for xml auto?

990

What do you understand by SQL*Net?

972

What is difference between equi join and inner join?

867

What do you understand by sql server agent?

921

Explain Geography datatype in SQL Server

1074

What are the differences between left join and inner join in sql server?

1055

What are recommended options to be used while using db mirroring? : sql server database administration

1088

What is data source view or dsv? : sql server analysis services, ssas

956

What are trace flags?

970

Explain different types of Normalization.

1749