Oracle 18c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table test (
A varchar(10),
B varchar(10),
STATUS VARCHAR (10),
LOAD_DATE date,
RANKNO int);
INSERT INTO test (A,B,STATUS,LOAD_DATE,RANKNO)
SELECT 'SAMPLE','SAMPLE','VALID',TO_DATE('2022-01-01', 'yyyy-mm-dd'),3 FROM DUAL UNION ALL
SELECT 'SAMPLE','SAMPLE','INVALID',TO_DATE('2022-01-01', 'yyyy-mm-dd'),5 FROM DUAL UNION ALL
SELECT 'SAMPLE','SAMPLE','VALID',TO_DATE('2022-01-01', 'yyyy-mm-dd') ,6 FROM DUAL UNION ALL
SELECT 'SAMPLE','SAMPLE','VALID',TO_DATE('2022-01-10', 'yyyy-mm-dd'),10 FROM DUAL UNION ALL
SELECT 'SAMPLE','SAMPLE','INVALID',TO_DATE('2022-01-10', 'yyyy-mm-dd'),12 FROM DUAL UNION ALL
SELECT 'SAMPLE','SAMPLE','INVALID',TO_DATE('2022-01-10', 'yyyy-mm-dd'),14 FROM DUAL
6 rows affected

SELECT 
  A, B, Status, 
  load_date,
  RANKNO,
  ROWNUM
FROM test 
WHERE status = 'VALID' 
ORDER BY 
  load_date ASC,
  RANKNO DESC
fetch first 1 rows only;


A
B
STATUS
LOAD_DATE
RANKNO
ROWNUM


SAMPLE
SAMPLE
VALID
01-JAN-22
6
2