'Count': Counts the number of non-null values. 'Count(*)�

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

Question Posted / guest

Answer Posted / guest

'Count': Counts the number of non-null values.
'Count(*)': Counts the number of rows in the table,
including null values and duplicates.

Is This Answer Correct ?

42 Yes

2 No

Please Help Members By Posting Answers For Below Questions

How to create database with physical files specified in ms sql server?

1034

How does stuff differ from the replace function?

1064

How to enforce security in sql server? : sql server security

1161

What are data files?

1091

List types of tables in SQL Azure?

128

What is wide table?

1012

How to enter comments in transact-sql statements?

985

How to insert data with null values?

1078

What does the on delete cascade option do?

1062

What is the cpu pressure?

1107

What structure can you implement for the database to speed up table reads?

1232

Do you know exporting and importing utility?

1103

Why use “pivot” in sql server?

1174

How to rename an existing column with sql server management studio?

1044

how to do partition in sqlserver

2545