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 are the disadvantages of using querystrings to send data from one page to another?

949

Which table keeps information about stored procedures?

894

What is the Disadvantage of indexed sequential file.

1033

Can we delete data from a view?

888

What is transact-sql ddl trigger?

1058

how will add additional conditions in sql?

1029

Explain the disadvantages of cursors?

1065

What is key attribute?

880

How to delete an existing database user?

977

How can you tell if a database object is invalid?

1028

List out the differences between the clustered index and non-clustered index in sql server?

951

What command would you use to add a column to a table in sql server?

1250

Tell me what is difference between clustered and non clustered index?

902

Can I save my report as html, excel or word? : sql server management studio

911

How to achieve Paging of records in SQL SERVER?

1054