Hi Team,
My requirement is.. I have to take count of I'd on two different conditions as follows
1.Count (distinct case when mndtry='infosec ' then I'd end )
2.Count (distinct case when mndtry='integrity' then I'd end )
If I write Count (distinct case when mndtry in('infosec ','integrity' then I'd end )
It doesn't give the correct result more than expectation,
Hence I need to take the count individually on common I'd.
How to achieve this.. Please suggest.
Regards,
Inam