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 is difference between table aliases and column aliases? Do they affect performance?

913

How can I check if a view exists in a sql server database?

984

What do you mean by normalisation?

964

Can you explain what is the use of custom fields in report?

1002

explain different levels of normalization? : Sql server database administration

932

What are views used for?

967

How to encrypt data between dialogs?

1033

How do I start sql server 2017?

888

What is an identity column in insert statements?

970

What are commonly used mssql functions in php?

1001

Why does sql studio use a single registered database repository? : sql server management studio

956

What options are there to delete rows on the publisher and not on the subscriber? : sql server replication

1148

How to list all user defined functions in the current database?

977

Tell me what is normalization? Explain different forms of normalization?

983

Describe in brief databases and sql server databases architecture.

944