Db2 Developer-C 11.1

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table test (id int, col_a varchar(10), col_b varchar(10), col_c varchar(10), col_d varchar(10));
insert into test values (1 , '1', 'd', 'f', 'e');
insert into test values (2 , 'r', 'g', 'v', 's');
insert into test values (2 , 'r', 's', 'v', 's');
insert into test values (3 , 'dd', 'ee', 'tt', 'ww');
insert into test values (3 , 'rf', 'DD', 'tt', 'ww');
insert into test values (3 , 'dd', 'DD', 'tt', 'ww');
select id
       , case when c_a = 1 then null else 'True' end
       , case when c_b = 1 then null else 'True' end
       , case when c_c = 1 then null else 'True' end
       , case when c_d = 1 then null else 'True' end
       , c
from (
select id
       , count(distinct col_a) c_a
       , count(distinct col_b) c_b
       , count(distinct col_c) c_c
       , count(distinct col_d) c_d
       , count(*) c
from test
group by id)


ID
2
3
4
5
C


1
null
null
null
null
1

2
null
True
null
null
2

3
True
True
null
null
3

ID	2	3	4	5	C
1	null	null	null	null	1
2	null	True	null	null	2
3	True	True	null	null	3