CODEWITHSUNDEEP
sqlcount
Para
Para

Reputation: 2082

can count(*) return a different result from just count

for example can this query

select count(*) from table

return something different than this query:

select count(column) from table

?

Upvotes: 1

Views: 103

Answers (1)

Habib
Habib

Reputation: 223322

  • COUNT(*) counts all rows
  • COUNT(column) counts non-NULLs only

Upvotes: 5

Related Questions