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

How can I create a report based on a query? : sql server management studio

1015

What is the difference between Clustered and Non-Clustered Index?

1059

What is sql collation?

1209

What is inline table-value user-defined function?

1112

List the types of recovery model available in sql server?

928

What are xml indexes?

952

Can you explain what is sql server english query?

996

What are the types of dml?

979

Ms sql server index?

1063

What is best institute to Learn DotNET And SQL in chennai?

2162

What is collation sensitivity? Explain different types.

1010

What is extent? Types of extents?

1193

How many types of stored procedures are there in sql server?

1015

Is it possible to call a stored procedure within a stored procedure?

976

How to delete multiple rows with one delete statement in ms sql server?

1024