By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE ABC
("Id" int, "Name" varchar(2), "Date" timestamp, "Execution id" int)
;
INSERT ALL
INTO ABC ("Id", "Name", "Date", "Execution id")
VALUES (1, 'AA', '09-Sep-2019 12:00:00 AM', 11)
INTO ABC ("Id", "Name", "Date", "Execution id")
VALUES (1, 'AA', '08-Sep-2019 12:00:00 AM', 22)
INTO ABC ("Id", "Name", "Date", "Execution id")
VALUES (1, 'AA', '07-Sep-2019 12:00:00 AM', 33)
INTO ABC ("Id", "Name", "Date", "Execution id")
VALUES (2, 'BB', '09-Sep-2019 12:00:00 AM', 44)
INTO ABC ("Id", "Name", "Date", "Execution id")
VALUES (2, 'BB', '08-Sep-2019 12:00:00 AM', 55)
INTO ABC ("Id", "Name", "Date", "Execution id")
VALUES (2, 'BB', '07-Sep-2019 12:00:00 AM', 66)
SELECT * FROM dual
;
6 rows affected
select t.* from ABC t
where not exists (
select 1 from ABC
where "Id" = t."Id" and "Name" = t."Name" and "Date" > t."Date"
)
| Id | Name | Date | Execution id |
|---|---|---|---|
| 1 | AA | 09-SEP-19 12.00.00.000000 AM | 11 |
| 2 | BB | 09-SEP-19 12.00.00.000000 AM | 44 |