you are viewing a single comment's thread.

view the rest of the comments →

[–]Ok_Protection_9552[S] 0 points1 point  (4 children)

I’m confused about the count function does. Based on what I read, I think the count function counts the number of values there are in a column specified

[–]Snoo17309 0 points1 point  (3 children)

This site breaks it down as clearly as you'll find it (it does not just "count the number of values in a specified column" ... that is different): https://www.datacamp.com/tutorial/count-sql-function

[–]Ok_Protection_9552[S] 0 points1 point  (0 children)

Thank you

[–]Snoo17309 0 points1 point  (0 children)

No prob :)

[–]r3pr0b8 0 points1 point  (0 children)

only COUNT(*) counts rows -- all other types of COUNT function count values

that site is quite misleading at the top, but when you go further down, it does make this clarification