SQL Server 2022

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

create table mytable (
  primary_id  int,     
  secondary_id varchar(20),  
  delete_flag int
);

insert into mytable values
('1', 'ajdkl', '1'),
('1', 'jnami', '0'),
('2', 'janda', '0'),
('3', 'wwqia', '1'),
('3', 'wwqia', '1'),
('4', 'lamse', '1'),
('4', 'pppqw', '1'),
('4', 'aneqw', '0'),
('5', 'gaabs', '1'),
('5', 'iikam', '1');
10 rows affected

select primary_id 
from mytable 
group by primary_id 
having count(delete_flag) = count(case when delete_flag = 1 then 1 end)


primary_id


3

5


Warning: Null value is eliminated by an aggregate or other SET operation.


select primary_id 
from mytable 
group by primary_id 
having min(delete_flag) = 1 and max(delete_flag) = 1


primary_id


3

5