SQL Server 2022

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

create table table1 (
  id integer, 
  check_col varchar(5)
  );
insert into table1 values 
(9052, 'N'),
(9052, 'Y'),
(2049, 'N'),
(2049, 'Y'),
(6940, 'N'),
(6940, 'Y'),
(7941, 'N'),
(8118, 'N'),
(8187, 'N');
9 rows affected

select 
 id, 
 max(check_col) as check_col
from table1
group by id
order by id


id
check_col


2049
Y

6940
Y

7941
N

8118
N

8187
N

9052
Y