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

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

Question Posted / t.lakshmi

Answer Posted / t.lakshmi

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

Is This Answer Correct ?

9 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Explain can you implement data mining in ssrs?

122

what's the information that can be stored inside a bit column? : Sql server database administration

771

What is log cache in sql server?

766

What is sql stored procedure?

831

How can you ensure that the database and sql server based application perform well?

840

What is lock escalation? : sql server database administration

878

How do I start sql server 2016?

714

How do I partition a table in sql server?

758

Write an sql query for deleting duplicate rows?

776

What is rolap and its advantage? : sql server analysis services, ssas

1005

When is the use of update_statistics command?

780

Write the queries for commands like Create Table, Delete table, Drop Table etc.

809

How to add an address record into adventureworkslt?

786

What's new in sql management studio for sql server? : sql server management studio

806

Explain transaction server distributed transaction?

723