Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
COUNT DISTINCT with condition
Message
From
22/04/2014 12:33:18
 
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Title:
COUNT DISTINCT with condition
Environment versions
SQL Server:
SQL Server 2012
Application:
Desktop
Miscellaneous
Thread ID:
01598897
Message ID:
01598897
Views:
56
I have a SQL Query that counts the number of employees in the query.
COUNT(Distinct paEmKey) AS EmployeesCount
I also need another count, but that would be based on a condition of another field.
So if I were to use a case statement it would look like, but that obviously cannot work.
CASE Balance <> 0.00 THEN COUNT(Distinct paEmKey) ELSE 0 END AS EmployeesCountWithBalances
I thought perhaps a subquery, but maybe there is a better way?
Christian Isberner
Software Consultant
Next
Reply
Map
View

Click here to load this message in the networking platform