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: 2796 | Points: 40

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

| Alert Moderator 

Comments or Responses

Login to post response