Oracle 11g Release 2

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

CREATE TABLE persons (ID int, Name varchar2(8), FirstName varchar2(8), Country varchar2(7));
INSERT ALL 
    INTO persons (ID, Name, FirstName, Country)
         VALUES (1, 'Doe', 'John', 'USA')
    INTO persons (ID, Name, FirstName, Country)
         VALUES (2, 'Doe', 'John', 'UK')
    INTO persons (ID, Name, FirstName, Country)
         VALUES (3, 'Doe', 'John', 'Brazil')
    INTO persons (ID, Name, FirstName, Country)
         VALUES (4, 'Meyer', 'Julia', 'Germany')
    INTO persons (ID, Name, FirstName, Country)
         VALUES (5, 'Meyer', 'Julia', 'Austria')
    INTO persons (ID, Name, FirstName, Country)
         VALUES (6, 'Picard', 'Jean-Luc', 'France')
    INTO persons (ID, Name, FirstName, Country)
         VALUES (7, 'Picard', 'Jean-Luc', 'UK')
    INTO persons (ID, Name, FirstName, Country)
         VALUES (8, 'Nakamura', 'Hikaro', 'Japan')
SELECT * FROM dual
;
8 rows affected

SELECT p1.*
FROM persons p1
WHERE EXISTS (
  SELECT *
  FROM persons p2
  WHERE p2.ID <> p1.ID
    AND p2.Name = p1.Name AND p2.FirstName = p1.FirstName 
    AND 'UK' IN (p1.Country, p2.Country)
);


ID
NAME
FIRSTNAME
COUNTRY


1
Doe
John
USA

2
Doe
John
UK

3
Doe
John
Brazil

6
Picard
Jean-Luc
France

7
Picard
Jean-Luc
UK

ID	NAME	FIRSTNAME	COUNTRY
1	Doe	John	USA
2	Doe	John	UK
3	Doe	John	Brazil
6	Picard	Jean-Luc	France
7	Picard	Jean-Luc	UK