Oracle 11g Release 2

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

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