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 a join?

1003

what are the new features introduced in sql server 2000? : Sql server database administration

871

Can group by and orderby be used together?

963

What is a schema in ms sql server 2005?

915

How do I find my localdb version?

938

How to handle error or exception in sql?

935

How can sql server instances be hidden? : sql server security

1053

What is data modification?

896

What is the difference between sdf and mdf?

1231

What are pages and extents? : SQL Server Architecture

956

Can two tables share a primary key?

950

what is the difference between delete table and truncate table commands? : Sql server database administration

963

What is the default schema of your login session in ms sql server?

993

how many triggers you can have on a table? : Sql server database administration

904

How to execute stored procedure and set temp table in sql server?

993