SQL Server 2022

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

create table yourtable (user_id int, store_id int);
insert into yourtable values (1,1);
1 rows affected

insert into yourtable values (1,2);
1 rows affected

insert into yourtable values (2,1);
1 rows affected

insert into yourtable values (3,1);
1 rows affected

insert into yourtable values (4,1);
1 rows affected

insert into yourtable values (4,2);
1 rows affected

insert into yourtable values (5,3);
1 rows affected

SELECT y.user_id
FROM yourtable y
WHERE y.store_id = 1
AND NOT EXISTS
  (SELECT 1 FROM yourtable y1 
     WHERE y.user_id = y1.user_id
     AND y1.store_id <> 1);


user_id


2

3