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 are the different types of stored procedures?

1117

How to download and install microsoft .net framework version 2.0?

1139

Can we hide the definition of a stored procedure from a use?

1223

What is bcp? When does it use?

943

why would you call update statistics? : Sql server database administration

1086

Why do we partition data?

1028

What is use of attribute hierarchy optimized state? : sql server analysis services, ssas

1063

How to update multiple rows with one update statement in ms sql server?

1203

What is acid properties?

1097

Explain the first normal form(1nf)?

1023

Tell me what is sql profiler?

1027

How you can get a list of all the table constraints in a database?

956

How to rebuild master databse?

1081

How to read data in a table with "select" statements?

967

How to write a query with a right outer join in ms sql server?

913