In SQL Server, what is the difference between Count(*) and Count(column_name) ?

Posted by Akiii on 5/31/2012 | Category: Sql Server Interview questions | Views: 4108 | Points: 40

Post |

Interview FAQs |

Exclusive Questions |

Interview Home

Answer:

Count(*) - Will count all the rows in the specified table

Count(column_name) - returns the number of rows which have a value (NULL values will not be counted)

Thanks and Regards
Akiii

| Alert Moderator

Bookmark It

< Previous : What is meaning of COUNT(DISTINCT column_name) ?

Next > : If we can execute multiple sql statements inside a ...

Comments or Responses

More Interview Questions by Akiii

If we can execute multiple sql statements inside a stored procedure. W ...
Can we declare abstract keyword on fields in a class ?
When any method is declared as abstract then it is necessary to declar ...
By default, what is the access specifier of member variables and membe ...
In Method Overriding, the return type can be changed while overriding ...
While doing Method Overloading, return type must be same. True or Fa ...
In ASP.NET Session Management, State Server uses which process to stor ...
If any fields/property/method is declared as static, will the data be ...

Latest Interview Questions

What is the OData ?
Which condition has high performance among this : int i = 5; 1 . ...
What is Json.net ?
what is node.js ?
What is WIF ?
What is WebSocket Protocol ?
WHAT IS VIEW IN SQL SERVER ?HOW MANY TYPES OF VIEW AVAILABLE?
WHAT IS TRIGGER IN SQL SERVER?
More ...