SQLite 3.39

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

select sqlite_version();


sqlite_version()


3.39.1


create table results (
id int,
test_result varchar(20),
diagnosis varchar(3)
);

insert into results values
(2,	'POSITIVE',	'X78'),
(2,	'NEGATIVE',	'U98'),
(3,	'POSITIVE',	'U98'),
(4,	'NFEGATIVE',	'Y55');
✓
SELECT
    *
FROM results r1
WHERE EXISTS (
    SELECT 1
    FROM results r2
    WHERE r1.id = r2.id AND r1.test_result != r2.test_result
)


id
test_result
diagnosis


2
POSITIVE
X78

2
NEGATIVE
U98

`id`	`test_result`	`diagnosis`
`2`	`POSITIVE`	`X78`
`2`	`NEGATIVE`	`U98`