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 different types of statement?

1017

What is the difference between char, varchar and nvarchar?

1024

What does <> symbol mean?

974

Find first and last day of current month in sql server

1028

How dts is used to extract, transform and consolidate data?

1073

Which sql server table is used to hold the stored procedure script?

948

Do you know what is fill factor and pad index?

1004

Explain intellisense for query editing

1029

What are temporal tables in sql server 2016?

884

What is Federation and Federation Member?

How many ways to create table-valued functions?

986

What is the purpose of grouping data in a report?

968

How to recreate an existing index in ms sql server?

1057

Can another user execute your local temporary stored procedures?

987

How does Report Builder support Analysis Services cubes?

153