Oracle 11g Release 2

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

CREATE TABLE mytable(
   Item_Number   INTEGER  NOT NULL
  ,Customer      INTEGER  NOT NULL
  ,Creation_Date VARCHAR(9) NOT NULL
  ,Onhand_Qty    INTEGER  NOT NULL
);
INSERT INTO mytable(Item_Number,Customer,Creation_Date,Onhand_Qty) VALUES (123,1,'03-FEB-19',654);
1 rows affected

INSERT INTO mytable(Item_Number,Customer,Creation_Date,Onhand_Qty) VALUES (234,3,'03-FEB-19',987);
1 rows affected

INSERT INTO mytable(Item_Number,Customer,Creation_Date,Onhand_Qty) VALUES (789,5,'03-FEB-19',874);
1 rows affected

INSERT INTO mytable(Item_Number,Customer,Creation_Date,Onhand_Qty) VALUES (321,4,'03-FEB-19',147);
1 rows affected

INSERT INTO mytable(Item_Number,Customer,Creation_Date,Onhand_Qty) VALUES (567,7,'03-FEB-19',632);
1 rows affected

INSERT INTO mytable(Item_Number,Customer,Creation_Date,Onhand_Qty) VALUES (123,1,'29-JAN-19',547);
1 rows affected

INSERT INTO mytable(Item_Number,Customer,Creation_Date,Onhand_Qty) VALUES (234,3,'29-JAN-19',814);
1 rows affected

INSERT INTO mytable(Item_Number,Customer,Creation_Date,Onhand_Qty) VALUES (789,5,'29-JAN-19',458);
1 rows affected

INSERT INTO mytable(Item_Number,Customer,Creation_Date,Onhand_Qty) VALUES (321,4,'29-JAN-19',330);
1 rows affected

INSERT INTO mytable(Item_Number,Customer,Creation_Date,Onhand_Qty) VALUES (567,7,'29-JAN-19',118);
1 rows affected

SELECT * FROM (
    SELECT t.*, ROW_NUMBER() OVER(PARTITION BY Customer, Item_Number ORDER BY creation_date DESC) rn
    FROM mytable t
) WHERE rn = 1


ITEM_NUMBER
CUSTOMER
CREATION_DATE
ONHAND_QTY
RN


123
1
29-JAN-19
547
1

234
3
29-JAN-19
814
1

321
4
29-JAN-19
330
1

789
5
29-JAN-19
458
1

567
7
29-JAN-19
118
1

ITEM_NUMBER	CUSTOMER	CREATION_DATE	ONHAND_QTY	RN
123	1	29-JAN-19	547	1
234	3	29-JAN-19	814	1
321	4	29-JAN-19	330	1
789	5	29-JAN-19	458	1
567	7	29-JAN-19	118	1