Manoj Pandey asks what the difference between COUNT(*) and COUNT(1) is:
So, we can clearly and without any doubt say that both COUNT(*) & COUNT(1) are same and equivalent.
Both of these are different from COUNT(SomeColumnName), though.
A Fine Slice Of SQL Server
Manoj Pandey asks what the difference between COUNT(*) and COUNT(1) is:
So, we can clearly and without any doubt say that both COUNT(*) & COUNT(1) are same and equivalent.
Both of these are different from COUNT(SomeColumnName), though.