count fetches non-null value from out of a query but count (*) includes nu

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

Question Posted / manisha

Answer Posted / manisha

count fetches non-null value from out of a query but count
(*) includes null values also.

Is This Answer Correct ?

5 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is local temp table?

907

What is dbcc updateusage?

1158

Explain multiserver query

974

Explain what is the difference between a local and a global temporary table?

947

How to list all user defined functions in the current database?

991

What are the advantages of policy management?

954

What is serializable?

1001

Explain the difference between cross join and full outer join?

928

What is nested transaction?

1056

How to execute multiple stored procedures at one time in sql server?

954

What is wrong with sql server client libarary dll, ntwdblib.dll?

1003

What is page-level compression?

911

What is the difference between the export /import functions in sql studio and standalone sql manager? : sql server management studio

1082

Show Practically Sql Server Views are updatable?

1064

explain different types of joins? : Sql server database administration

937