Oracle 11g Release 2

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

create table Registro (
Folio number(12),
id number(3), 
indicador number(1)
)
insert into Registro values (1907050173,1,1);
1 rows affected

insert into Registro values (1907050173,6,1);
1 rows affected

insert into Registro values (1907050173,16,1);
1 rows affected

insert into Registro values (1907050173,15,1);
1 rows affected

insert into Registro values (1907050174,16,1);
1 rows affected

insert into Registro values (1907050174,15,1);
1 rows affected

insert into Registro values (1907050175,2,1);
1 rows affected

insert into Registro values (1907050175,3,1);
1 rows affected

select * from registro;


FOLIO
ID
INDICADOR


1907050173
1
1

1907050173
6
1

1907050173
16
1

1907050173
15
1

1907050174
16
1

1907050174
15
1

1907050175
2
1

1907050175
3
1


select a.folio
from registro a,
     (select folio, count(distinct id) qty
      from registro
      group by folio) b
where a.id in (15,16) 
and a.folio = b.folio
group by a.folio, b.qty
having count(distinct a.id) = 2 and count(distinct a.id) = b.qty


FOLIO


1907050174

FOLIO	ID	INDICADOR
1907050173	1	1
1907050173	6	1
1907050173	16	1
1907050173	15	1
1907050174	16	1
1907050174	15	1
1907050175	2	1
1907050175	3	1