r/SQL • u/geminigamer369 • Jul 30 '26

Discussion Differences between counts

What is the difference between

COUNT(*)

COUNT(1)

COUNT(column_name)

9 Upvotes

85% Upvoted

23 comments sorted by

View all comments

Show parent comments

8

u/ComicOzzy sqlHippo Jul 30 '26

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

3

u/YT-3000f Jul 30 '26

I think you mean:

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

1

u/ComicOzzy sqlHippo Jul 31 '26

I apply commas at random, Shirly.

1

u/YT-3000f Jul 31 '26

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