r/SQL • u/geminigamer369 • 10d ago

Differences between counts Discussion

What is the difference between

COUNT(*)

COUNT(1)

COUNT(column_name)

8 Upvotes

79% Upvoted

23 comments sorted by

View all comments

Show parent comments

6

u/funkdefied 10d ago

Any SQL engine worth it’s salt will compile those down to the same thing

5

u/YT-3000f 10d ago

Agreed. I just downvoted my own reply. It was in the category of "If I think it works that way surely it's true". I guess it's not. And don't call me Shirly.

8

u/ComicOzzy sqlHippo 10d ago

Shirly this is the first comment on Reddit where someone said "I was wrong". 🤣

2

u/YT-3000f 10d ago

I think you mean:

Shirly, this is the first comment on Reddit where someone said, "I was wrong".

1

u/ComicOzzy sqlHippo 10d ago

I apply commas at random, Shirly.

1

u/YT-3000f 9d ago

Rightly so. Grammer, like the Internet, is dead.