Oracle 18c

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

CREATE TABLE test1 ( id INT PRIMARY KEY, val VARCHAR(255));
CREATE TABLE test2 ( id INT PRIMARY KEY, val VARCHAR(255));
INSERT INTO test1
SELECT 1, 'Иван' FROM DUAL UNION ALL
SELECT 2, 'Дмитрий' FROM DUAL;
2 rows affected

INSERT INTO test2
SELECT 1, 'Иван' FROM DUAL UNION ALL
SELECT 2, 'Василий' FROM DUAL;
2 rows affected

-- Вывести id записей, которые не совпадают
SELECT id
FROM test1
NATURAL FULL JOIN test2
GROUP BY id
HAVING COUNT(id) = 2;


ID


2