By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| TESTNAME | (CASEWHENMAX(STATUS)KEEP(DENSE_RANKFIRSTORDERBYTIMESTAMPDESC)='PASSED'ANDSUM(CASEWHENSTATUS='FAILED'THEN1ELSE0END)>0THEN'PASSED_ON_RERUN'ELSEMAX(STATUS)KEEP(DENSE_RANKFIRSTORDERBYTIMESTAMPDESC)END) |
|---|---|
| 123 | Failed |
| ABC | Passed_On_Rerun |
| EFG | Passed |