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

Types of Authentications in Sql Server? How user gets authenticated through windows authentication?

1051

How to list all tables in the database using odbc_tables()?

1048

How to create sub reports?

242

how to create “alternate row colour”?

146

what are the reporting service components in SSRS?

163

How is table type constraint applied to a table?

977

What are differences in between sql server 2012 and sql server 2016?

1044

What is DCL?

1049

Can You Use Data Mining Models In Ssrs?

145

How to find index size for each index on table?

1003

Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?

2502

What sql server means?

965

Explain boyce and codd normal form(bcnf)?

956

What are the approximate numeric data types?

923

What is data source document?

1039