Blog: Provides a list of Dotnet FAQS which are of Difference between kind. Blog Category: Content Aggregation Total Posts: 255 Total Questions & Answers: 380 Source: Websites, blogs, forums, ebooks,books and other references Note: The information provided in this blog may contain typos
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)
No comments:
Post a Comment