How to count two fields in a query but not count the duplicates?

[dduva]

I have a query where I am selecting fields a, b, and c. I am grouping by a. I want to get a count of b and c. The problem is there are duplicates in b. Column c has no duplicates. How can I count all of column c, only the unique records in column b and group by a. Thanks in advance.

Devin

 

[BPeisch]

This may work:

SELECT a, count(distinct b), count(c) ;
   FROM MyTable ;
   GROUP BY a

-BP (Barbara Peisch)

http://www.peisch.com

 

[dduva]

That worked. Didn't know I could put distinct inside the count.

Thank you.

 

[BPeisch]

Didn't know I could put distinct inside the count.

Yeah, it's not documented very well.


-BP (Barbara Peisch)

http://www.peisch.com