'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

If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?

967

How to recover from sql injection? : sql server security

1018

Can I run multiple instances of sql server 2000 at the same time on one computer?

1074

What functions can a view be used to performed?

1060

Why people hate cursor?

1147

Is truncate a dml command?

950

Define primary key?

1140

What happens when converting big values to integers?

999

What is difference between oltp and olap?

1049

What is sql sandbox in sql server?

1226

What is rank function?

1032

what kind of lan types do you know? : Sql server database administration

980

What are logical database components? : SQL Server Architecture

1037

What do you mean by data manipulation language?

1019

What is a transact-sql statement batch in ms sql server?

1019