Philippe Renaud
asked on
SELECT Count with CASE
Hi guys, I am trying to do a SQL statement fo this matter:
I need to return 1 (for true) if in my table user_tables I got for my column isJoin the count of 6 .
in addition to the count, I need check there is no value of 0 on that column. Example:
IsJoin: 1 2 3 0 0 4
Count = 6 , but got 2 zero, So i would return false.
Example:
IsJoin : 1 2 3 4 5 6
count = 6, no zero: Return true.
I didnt find the way to do it in SQl.. can you help ?
I need to return 1 (for true) if in my table user_tables I got for my column isJoin the count of 6 .
in addition to the count, I need check there is no value of 0 on that column. Example:
IsJoin: 1 2 3 0 0 4
Count = 6 , but got 2 zero, So i would return false.
Example:
IsJoin : 1 2 3 4 5 6
count = 6, no zero: Return true.
I didnt find the way to do it in SQl.. can you help ?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Select Case When (Select Sum(Case When IsJoin = 0 Then 0 Else 1 End) As [Count] From User_Tables) = 6 Then 1 Else 0 End As Result
For example.
Tim Cottee