MySQL 8.0

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

create table t1(request_id int, p_id int)
insert into t1 values
(66,10),
(66,10),
(66,10),
(66,22),
(66,22),
(76,23),
(76,24)

Records: 7  Duplicates: 0  Warnings: 0


select * from t1 
where (request_id, p_id) NOT IN ((66, 10),(76,23)) 


request_id
p_id


66
22

66
22

76
24


select left('fahmina@augmedix.com', charindex('@', 'fahmina@augmedix.com' + '@')-1)

FUNCTION fiddle.charindex does not exist