Count(exp): Counts the number of rows excluding null values. Count(*) : Co

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

Question Posted / vijay dev saxena

Answer Posted / vijay dev saxena

Count(exp): Counts the number of rows excluding null values.
Count(*) : Counts the number of rows including null and
duplicates records.

Is This Answer Correct ?

13 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How many columns can we include on clustered index ?

1053

Relational calculus is what type of language?

1090

How to convert numeric expression data types using the cast() function?

1116

explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?

2540

Define Wed Edition in SQL Azure?

102

Explain the creation and execution of a user-defined function in the sql server?

1103

Can we use where clause in union?

1122

Explain about SQLOS?

1052

What is database black box testing?

1068

What is hot add cpu in sql server 2008?

979

How to test subquery results with the exists operator?

1163

Give the query of getting last two records from the table in SQL SERVER?

1008

How do I know if localdb is running?

993

What is database isolation in sql server? : sql server database administration

1147

How each E-R model constructs can be mapped to the relational model?

1046