By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE t (
`ID` INTEGER,
`RESULT_DATE1` TEXT,
`RESULT_TIME_1` VARCHAR(8),
`FINAL_DATE1` TEXT,
`FINAL_TIME_1` VARCHAR(8)
);
INSERT INTO t
(`ID`, `RESULT_DATE1`, `RESULT_TIME_1`, `FINAL_DATE1`, `FINAL_TIME_1`)
VALUES
('766', '11/13/2020', '12:12:12', '11/29/2020', '13:11:12'),
('766', '11/13/2020', '12:12:12', '11/29/2020', '14:11:12'),
('765', '10/13/2020', '12:12:12', '10/14/2020', '11:11:12'),
('765', '10/20/2021', '12:12:12', '10/21/2020', '12:13:14');
✓
select ID
,RESULT_DATE1
,RESULT_TIME_1
,FINAL_DATE1
,FINAL_TIME_1
from (
select *
,row_number() over (partition by ID order by FINAL_DATE1 desc,FINAL_TIME_1 desc) as rn
from t
) t
where rn = 1
ID |
RESULT_DATE1 |
RESULT_TIME_1 |
FINAL_DATE1 |
FINAL_TIME_1 |
|---|---|---|---|---|
765 |
10/20/2021 |
12:12:12 |
10/21/2020 |
12:13:14 |
766 |
11/13/2020 |
12:12:12 |
11/29/2020 |
14:11:12 |