create table Test(name varchar2(10),process varchar2(5), flag varchar(1));
insert into table values ('TEST1','A','Y');
insert into table values ('TEST1','B','Y');
insert into table values ('TEST1','C','Y');
insert into table values ('TEST2','A','Y');
insert into table values ('TEST2','B','Y');
insert into table values ('TEST2','C','N');
insert into table values ('TEST3','A','Y');
insert into table values ('TEST3','B','Y');
insert into table values ('TEST3','C','Y');
insert into table values ('TEST4','','');
insert into table values ('TEST4','B','Y');
insert into table values ('TEST4','C','Y');
My requirement is if
1)flag column is 'N' then I have to display falg is N for TEST2.
2) if flag and process null then I have to display flag(Y) and process(C) is not exist for TEST4.