Details
-
Bug
-
Status: Resolved
-
Minor
-
Resolution: Fixed
-
None
-
None
-
None
Description
default> select count * from table1; col1, col2, col3 ------------------------- a, b-1, null a, b-2, null a, b-2, null a, b-3, null a, b-3, null a, b-3, null default> select col1, count(distinct col2) as cnt1, count(distinct case when col3 is not null then col2 else null end) as cnt2 from table1 group by col1; col1,cnt1,cnt2 ------------------------------- a, 2, 1 null, 1, 1
This query should return the below result.
col1,cnt1,cnt2 ------------------------------- a, 3, 1