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

how you can configure a running aggregate in SSRS?

190

Explain the difference between delete,drop and truncate in SQL Server?

1100

Explain cursor as data base object?

1040

Will count(column) include columns with null values in its count?

1093

Explain what are the restrictions that views have to follow? : SQL Server Architecture

1048

What is statement level trigger?

998

Explain the ways to controlling cursor behavior?

919

What is xdr?

987

what are the core components of SSRS?

129

What is shrink log file?

897

How to Update from select query in sql server?

1061

How do you handle datasets larger than 50 gb?

162

What is the maximum size of sql server database?

1009

Is sql different from sql server?

1087

What is the cartesian product of the table?

958