The count(1) refers the count of records in the first column. If there are any null values in the first column, it won't count that record.
The count(*) refers the count of records on overall the columns. It will display the no.of records.
Thanks
Tuesday, 21 February 2017
What is the difference between count(1) and count(*) in SQL Server?
The count(1) refers the count of records in the first column. If there are any null values in the first column, it won't count that record.
The count(*) refers the count of records on overall the columns. It will display the no.of records.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment