SQL SERVER – Difference between COUNT(DISTINCT) vs COUNT(ALL)
- by pinaldave
This blog post is written in response to the T-SQL Tuesday hosted by Jes Schultz Borland. Earlier today, I was presenting a 45-minute session at the Community College about “The Beginning SQL Server Database”. One of the students asked me the following question.
What is the difference between COUNT(DISTINCT) vs COUNT(ALL)?
I found this question…