Oracle 21c

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

ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS';
CREATE TABLE test (c1, c2, c3) AS
SELECT 'a', 1, 1 FROM DUAL UNION ALL
SELECT 'b', 2, 3 FROM DUAL UNION ALL
SELECT 'c', 3, 2 FROM DUAL;
3 rows affected

SELECT *
FROM   test
ORDER BY GREATEST(c2, c3) DESC
FETCH FIRST ROW WITH TIES


C1
C2
C3


c
3
2

b
2
3


SELECT c1, c2, c3
FROM   (
  SELECT t.*,
         RANK() OVER (ORDER BY GREATEST(c2, c3) DESC) AS rnk
  FROM   test t
)
WHERE  rnk = 1;


C1
C2
C3


b
2
3

c
3
2