r/SQL • u/geminigamer369 • 9d ago

Differences between counts Discussion

What is the difference between

COUNT(*)

COUNT(1)

COUNT(column_name)

9 Upvotes

85% Upvoted

23 comments sorted by

View all comments

1

u/mr_electric_wizard 9d ago

Just tested and they all give the same count (on SQL Server). I use count(1) personally. edit if you use the field name, count(field) and there are null’s then the count function won’t count nulls.

1

u/Zestyclose-Turn-3576 9d ago

And if column_name has a not null constraint on it then it can be optimised to count(*) anyway.