select count(*) vs count(1) in sql server database
COUNT(SomeColumn) will only return
the count of rows that contain non-null values for SomeColumn.
COUNT(*) and COUNT('Foo') will return the total number of rows in the table.
Other else no such big difference between them.....
COUNT(*) and COUNT('Foo') will return the total number of rows in the table.
Other else no such big difference between them.....
Comments
Post a Comment