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

Can we use trigger new in before insert?

903

How to compose an inquiry to demonstrate the points of interest of an understudy from students table whose name begins with k?

1083

What is the use of set nocount on/off statement?

1076

What is the importance of three tier architecture?

1073

Explain about protocol layer present in SQL server?

1178

How many joins in sql server?

931

What are two difference between sql azure and azure tables?

159

What is precedence constraint?

968

What are the steps you should follow to start sql server in single-user mode?

880

What is the difference between osql and query analyzer?

974

Explain what are the different index configurations a table can have?

1094

What is nonclustered index with included columns ?

951

What is report server project?

145

What are the various editions of sql server 2017 that are available in the market?

882

Difference between Logical Page and Physical Page in SSRS.

474