emi_sastra
asked on
COUNT OR SUM WITH CONDITION
Hi All,
I try below code :
SELECT
SecCode
, SUM(CASE WHEN ISNULL(MemberOf, '') <> '' THEN 1 ELSE 0 END) AS Member
, SUM(CASE WHEN ISNULL(MemberOf, '') = '' THEN 0 ELSE 1 END) AS NonMember
FROM TMEMPLOYEE
WHERE ResignDate Is NULL
GROUP BY SecCode
ORDER BY SecCode
Both Member and NonMember have same number result, this is wrong query.
What should I do ?
Thank you.
I try below code :
SELECT
SecCode
, SUM(CASE WHEN ISNULL(MemberOf, '') <> '' THEN 1 ELSE 0 END) AS Member
, SUM(CASE WHEN ISNULL(MemberOf, '') = '' THEN 0 ELSE 1 END) AS NonMember
FROM TMEMPLOYEE
WHERE ResignDate Is NULL
GROUP BY SecCode
ORDER BY SecCode
Both Member and NonMember have same number result, this is wrong query.
What should I do ?
Thank you.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you very much for your help.