COUNT(Exp): COUNT the no of not NULL Records Including Duplicates values

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

Question Posted / mahavir bansal

Answer Posted / mahavir bansal

COUNT(Exp): COUNT the no of not NULL Records Including
Duplicates values
COUNT(*):returns the No of Records in the Table.

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What new data source types were added in ssrs 2014?

169

How to test subquery results with the exists operator?

1163

what are the new features in SSRS?

145

What is the primary use of the model database?

1128

Explain cdc and sql injection?

1041

What is database replication? What are the different types of replication you can set up in sql server?

1017

What is a derived table?

990

What types of replication are supported in sql server?

1111

How do I create a stored procedure in sql server?

1094

What is set nocount on and what is set nocount off?

993

What is a unique key constraint?

1085

What are the different types of sql server replication? : sql server replication

1365

Write a code to select distinct records without using the DISTINCT keyword.

1181

Determine how to use the inserted and deleted pseudo tables?

1041

How to connect of datebase with sql express.?

1143