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 are alternate keys?

945

What is subreport?

132

What is blocking and how would you troubleshoot it? : sql server database administration

1004

Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .

1917

Explain the difference between control flow and data flow?

946

What is the difference between commit and rollback?

889

How do you create an execution plan?

906

How to find out what is the default collation in a database?

1077

What do you understand by the denormalisation?

920

what is sql server? : Sql server database administration

946

What do you understand by sql server agent?

923

Explain iaas, paas and saas?

Explain try...catch with sql server?

985

What is left outer join in sql server joins?

989

what is the difference between them (ethernet networks and token ring networks)? : Sql server database administration

998