COUNT(DISTINCT A&B&C)

[Anonymous]

Can you please tell me when is this expression used.

count(distinct A&B&C)

where A,B,C are column names from my table.

[Gysbert_Wassenaar]

It is used when you want to know the number of unique combinations of values from fields A, B and C.