Blog Home  Home Feed your aggregator (RSS 2.0)  
Software Code Help - What is the difference between Count and Count(*) in SQL Server?
Blog
 
# Thursday, August 06, 2009

'Count': Counts the number of non-null values.


'Count (*)': Counts the number of rows in the table, including null values and duplicates.

Thursday, August 06, 2009 12:33:31 PM (GMT Daylight Time, UTC+01:00)  #    Comments [0]   Interview Question SQL  | 
Comments are closed.
Copyright © 2010 SoftwareCodeHelp. All rights reserved.
DasBlog 'Portal' theme by Johnny Hughes.
Pick a theme: