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

What is collation sensitivity? Explain different types.

1054

How to add an address record into adventureworkslt?

1027

Describe in brief system database.

1068

What is Sqlpaging in SqlServer 2005 ?

1115

What are the differences between decimal and float in ms sql server?

1344

Give a example to search fr a string in all stored procedure in sql server.

1059

What is mssql?

1031

What are the ways available in sql server to execute sql statements?

1204

How to implement service broker?

1069

How to rename an existing table with the "sp_rename" stored procedure in ms sql server?

1070

How to verify a user name with sqlcmd tool?

1118

What is use of attributehierarchyenabled? : sql server analysis services, ssas

1296

how to define testing of network layers? : Sql server database administration

1020

What are the properties of the transaction?

1051

What the different components of Replication and what is their use?

1123