TSQL Count 'Where' Condition

Viewed 25311

How do I implement the 'meaning' of the following psuedo-SQL statement:

COUNT(distinct id where attribute1 > 0)

In other words, how do I make conditional, distinct counting statements?

Thanks!

2 Answers
Related