8.23.2012

Difference between Count(*) and Count(column_name) in SQL Server

Difference between Count(*) and Count(column_name) in SQL Server
S.No
Count(*)
Count(column_name)
1
Will count all the rows in the specified table
Returns the number of rows which have a value (NULL values will not be counted)

1 comment: