One Star

[resolved] Difference between "unique" and "Distinct"

When I run the profiler, the 'simple' stats include two different counts: one for "unique" values and the other for "Distinct" values.
I don't understand the difference between them.
Can someone please explain how I should interpret the case when:
Row Count = 658,645 (OK, I think I understand this one Smiley Happy )
Null Count = 0 (I understand this one too Smiley Happy )
Distinct Count = 5,097
Unique Count = 541
Duplicate Count = 4,556

1 REPLY
Employee

Re: [resolved] Difference between "unique" and "Distinct"

"Distinct count" counts the number of distinct values of your column (SELECT DISTINCT ...)
"Unique count" counts the number of distinct values with only one instance. It is necessarily less or equal to "distinct counts"
"Duplicate count" count the number of values appearing more than once.
You have the relation:
"Duplicate count" + "Unique count" = "Distinct count"
For example,
a,a,a,a,b,b,c,d,e => 9 values, 5 distinct values, 3 unique values, 2 duplicate values.