By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
WITH yourTable AS (
SELECT 73 AS ID, 2000 AS Result UNION ALL
SELECT 73, 2000 UNION ALL
SELECT 43, 2000 UNION ALL
SELECT 43, 1003
)
SELECT DISTINCT ID
FROM yourTable t1
WHERE NOT EXISTS (SELECT 1 FROM yourTable t2 WHERE t1.ID = t2.ID AND t2.Result <> t1.Result);
| ID |
|---|
| 73 |