MySQL 5.7

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

CREATE TABLE tablename (
  `ID` INTEGER,
  `TestName` VARCHAR(13),
  `Result` VARCHAR(4)
);

INSERT INTO tablename
  (`ID`, `TestName`, `Result`)
VALUES
  ('1', 'Performance_1', 'PASS'),
  ('2', 'Performance_1', 'FAIL'),
  ('3', 'Performance_1', 'FAIL'),
  ('4', 'Smoke_9', 'FAIL'),
  ('5', 'Smoke_9', 'FAIL');
select TestName
from tablename
group by TestName
having sum(Result <> 'FAIL') = 0


TestName


Smoke_9


select t.* from tablename t
where not exists (select 1 from tablename where TestName = t.TestName and Result <> 'FAIL')


ID
TestName
Result


4
Smoke_9
FAIL

5
Smoke_9
FAIL