Oracle 23c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE table_name (id, col_1, col_2, col_3, col_4, col_5, col_6 ) AS
  SELECT 1, 2, 5, 2, 9, 4, 7 FROM DUAL UNION ALL
  SELECT 2, 2, 4, 3, 5, 4, 7 FROM DUAL UNION ALL
  SELECT 3, 2, 2, 3, 5, 4, 8 FROM DUAL;
3 rows affected

SELECT id,
       CASE
       WHEN r1 = 0 THEN col_1
       WHEN r2 = 0 THEN col_2
       WHEN r3 = 0 THEN col_3
       WHEN r4 = 0 THEN col_4
       WHEN r5 = 0 THEN col_5
       WHEN r6 = 0 THEN col_6
       END AS col_1,
       CASE
       WHEN r1 = 1 THEN col_1
       WHEN r2 = 1 THEN col_2
       WHEN r3 = 1 THEN col_3
       WHEN r4 = 1 THEN col_4
       WHEN r5 = 1 THEN col_5
       WHEN r6 = 1 THEN col_6
       END AS col_2,
       CASE
       WHEN r1 = 2 THEN col_1
       WHEN r2 = 2 THEN col_2
       WHEN r3 = 2 THEN col_3
       WHEN r4 = 2 THEN col_4
       WHEN r5 = 2 THEN col_5
       WHEN r6 = 2 THEN col_6
       END AS col_3,
       CASE
       WHEN r1 = 3 THEN col_1
       WHEN r2 = 3 THEN col_2
       WHEN r3 = 3 THEN col_3
       WHEN r4 = 3 THEN col_4
       WHEN r5 = 3 THEN col_5
       WHEN r6 = 3 THEN col_6
       END AS col_4
FROM   (
  SELECT id,
         col_1,
         CASE WHEN col_1 < col_2 THEN 1 ELSE 0 END
         + CASE WHEN col_1 < col_3 THEN 1 ELSE 0 END
         + CASE WHEN col_1 < col_4 THEN 1 ELSE 0 END
         + CASE WHEN col_1 < col_5 THEN 1 ELSE 0 END
         + CASE WHEN col_1 < col_6 THEN 1 ELSE 0 END r1,
         col_2,
         CASE WHEN col_2 <= col_1 THEN 1 ELSE 0 END
         + CASE WHEN col_2 < col_3 THEN 1 ELSE 0 END
         + CASE WHEN col_2 < col_4 THEN 1 ELSE 0 END
         + CASE WHEN col_2 < col_5 THEN 1 ELSE 0 END
         + CASE WHEN col_2 < col_6 THEN 1 ELSE 0 END r2,
         col_3,
         CASE WHEN col_3 <= col_1 THEN 1 ELSE 0 END
         + CASE WHEN col_3 <= col_2 THEN 1 ELSE 0 END
         + CASE WHEN col_3 < col_4 THEN 1 ELSE 0 END
         + CASE WHEN col_3 < col_5 THEN 1 ELSE 0 END
         + CASE WHEN col_3 < col_6 THEN 1 ELSE 0 END r3,
         col_4,
         CASE WHEN col_4 <= col_1 THEN 1 ELSE 0 END
         + CASE WHEN col_4 <= col_2 THEN 1 ELSE 0 END
         + CASE WHEN col_4 <= col_3 THEN 1 ELSE 0 END
         + CASE WHEN col_4 < col_5 THEN 1 ELSE 0 END
         + CASE WHEN col_4 < col_6 THEN 1 ELSE 0 END r4,
         col_5,
         CASE WHEN col_5 <= col_1 THEN 1 ELSE 0 END
         + CASE WHEN col_5 <= col_2 THEN 1 ELSE 0 END
         + CASE WHEN col_5 <= col_3 THEN 1 ELSE 0 END
         + CASE WHEN col_5 <= col_4 THEN 1 ELSE 0 END
         + CASE WHEN col_5 < col_6 THEN 1 ELSE 0 END r5,
         col_6,
         CASE WHEN col_6 <= col_1 THEN 1 ELSE 0 END
         + CASE WHEN col_6 <= col_2 THEN 1 ELSE 0 END
         + CASE WHEN col_6 <= col_3 THEN 1 ELSE 0 END
         + CASE WHEN col_6 <= col_4 THEN 1 ELSE 0 END
         + CASE WHEN col_6 <= col_5 THEN 1 ELSE 0 END r6
  FROM   table_name
)


ID
COL_1
COL_2
COL_3
COL_4


1
9
7
5
4

2
7
5
4
4

3
8
5
4
3


SELECT id,
       CASE
       WHEN r1 = 0 THEN col_1
       WHEN r2 = 0 THEN col_2
       WHEN r3 = 0 THEN col_3
       WHEN r4 = 0 THEN col_4
       WHEN r5 = 0 THEN col_5
       WHEN r6 = 0 THEN col_6
       END AS col_1,
       CASE
       WHEN r1 = 1 THEN col_1
       WHEN r2 = 1 THEN col_2
       WHEN r3 = 1 THEN col_3
       WHEN r4 = 1 THEN col_4
       WHEN r5 = 1 THEN col_5
       WHEN r6 = 1 THEN col_6
       END AS col_2,
       CASE
       WHEN r1 = 2 THEN col_1
       WHEN r2 = 2 THEN col_2
       WHEN r3 = 2 THEN col_3
       WHEN r4 = 2 THEN col_4
       WHEN r5 = 2 THEN col_5
       WHEN r6 = 2 THEN col_6
       END AS col_3,
       CASE
       WHEN r1 = 3 THEN col_1
       WHEN r2 = 3 THEN col_2
       WHEN r3 = 3 THEN col_3
       WHEN r4 = 3 THEN col_4
       WHEN r5 = 3 THEN col_5
       WHEN r6 = 3 THEN col_6
       END AS col_4
FROM   (
  SELECT id,
         col_1,
         r1
         - CASE WHEN r1 > r2 THEN e2 ELSE 0 END
         - CASE WHEN r1 > r3 THEN e3 ELSE 0 END
         - CASE WHEN r1 > r4 THEN e4 ELSE 0 END
         - CASE WHEN r1 > r5 THEN e5 ELSE 0 END
         - CASE WHEN r1 > r6 THEN e6 ELSE 0 END AS r1,
         col_2,
         r2
         - CASE WHEN r2 > r1 THEN e1 ELSE 0 END
         - CASE WHEN r2 > r3 THEN e3 ELSE 0 END
         - CASE WHEN r2 > r4 THEN e4 ELSE 0 END
         - CASE WHEN r2 > r5 THEN e5 ELSE 0 END
         - CASE WHEN r2 > r6 THEN e6 ELSE 0 END AS r2,
         col_3,
         r3
         - CASE WHEN r3 > r1 THEN e1 ELSE 0 END
         - CASE WHEN r3 > r2 THEN e2 ELSE 0 END
         - CASE WHEN r3 > r4 THEN e4 ELSE 0 END
         - CASE WHEN r3 > r5 THEN e5 ELSE 0 END
         - CASE WHEN r3 > r6 THEN e6 ELSE 0 END AS r3,
         col_4,
         r4
         - CASE WHEN r4 > r1 THEN e1 ELSE 0 END
         - CASE WHEN r4 > r2 THEN e2 ELSE 0 END
         - CASE WHEN r4 > r3 THEN e3 ELSE 0 END
         - CASE WHEN r4 > r5 THEN e5 ELSE 0 END
         - CASE WHEN r4 > r6 THEN e6 ELSE 0 END AS r4,
         col_5,
         r5
         - CASE WHEN r5 > r1 THEN e1 ELSE 0 END
         - CASE WHEN r5 > r2 THEN e2 ELSE 0 END
         - CASE WHEN r5 > r3 THEN e3 ELSE 0 END
         - CASE WHEN r5 > r4 THEN e4 ELSE 0 END
         - CASE WHEN r5 > r6 THEN e6 ELSE 0 END AS r5,
         col_6,
         r6
         - CASE WHEN r6 > r1 THEN e1 ELSE 0 END
         - CASE WHEN r6 > r2 THEN e2 ELSE 0 END
         - CASE WHEN r6 > r3 THEN e3 ELSE 0 END
         - CASE WHEN r6 > r4 THEN e4 ELSE 0 END
         - CASE WHEN r6 > r5 THEN e5 ELSE 0 END AS r6
  FROM   (
    SELECT id,
           col_1,
           CASE WHEN col_1 < col_2 THEN 1 ELSE 0 END
           + CASE WHEN col_1 < col_3 THEN 1 ELSE 0 END
           + CASE WHEN col_1 < col_4 THEN 1 ELSE 0 END
           + CASE WHEN col_1 < col_5 THEN 1 ELSE 0 END
           + CASE WHEN col_1 < col_6 THEN 1 ELSE 0 END AS r1,
           0 AS e1,
           col_2,
           CASE WHEN col_2 < col_1 THEN 1 ELSE 0 END
           + CASE WHEN col_2 < col_3 THEN 1 ELSE 0 END
           + CASE WHEN col_2 < col_4 THEN 1 ELSE 0 END
           + CASE WHEN col_2 < col_5 THEN 1 ELSE 0 END
           + CASE WHEN col_2 < col_6 THEN 1 ELSE 0 END AS r2,
           CASE WHEN col_2 = col_1 THEN 1 ELSE 0 END AS e2,
           col_3,
           CASE WHEN col_3 < col_1 THEN 1 ELSE 0 END
           + CASE WHEN col_3 < col_2 THEN 1 ELSE 0 END
           + CASE WHEN col_3 < col_4 THEN 1 ELSE 0 END
           + CASE WHEN col_3 < col_5 THEN 1 ELSE 0 END
           + CASE WHEN col_3 < col_6 THEN 1 ELSE 0 END AS r3,
           CASE WHEN col_3 = col_1 THEN 1 ELSE 0 END
           + CASE WHEN col_3 = col_2 THEN 1 ELSE 0 END AS e3,
           col_4,
           CASE WHEN col_4 < col_1 THEN 1 ELSE 0 END
           + CASE WHEN col_4 < col_2 THEN 1 ELSE 0 END
           + CASE WHEN col_4 < col_3 THEN 1 ELSE 0 END
           + CASE WHEN col_4 < col_5 THEN 1 ELSE 0 END
           + CASE WHEN col_4 < col_6 THEN 1 ELSE 0 END AS r4,
           CASE WHEN col_4 = col_1 THEN 1 ELSE 0 END
           + CASE WHEN col_4 = col_2 THEN 1 ELSE 0 END
           + CASE WHEN col_4 = col_3 THEN 1 ELSE 0 END AS e4,
           col_5,
           CASE WHEN col_5 < col_1 THEN 1 ELSE 0 END
           + CASE WHEN col_5 < col_2 THEN 1 ELSE 0 END
           + CASE WHEN col_5 < col_3 THEN 1 ELSE 0 END
           + CASE WHEN col_5 < col_4 THEN 1 ELSE 0 END
           + CASE WHEN col_5 < col_6 THEN 1 ELSE 0 END AS r5,
           CASE WHEN col_5 = col_1 THEN 1 ELSE 0 END
           + CASE WHEN col_5 = col_2 THEN 1 ELSE 0 END
           + CASE WHEN col_5 = col_3 THEN 1 ELSE 0 END
           + CASE WHEN col_5 = col_4 THEN 1 ELSE 0 END AS e5,
           col_6,
           CASE WHEN col_6 < col_1 THEN 1 ELSE 0 END
           + CASE WHEN col_6 < col_2 THEN 1 ELSE 0 END
           + CASE WHEN col_6 < col_3 THEN 1 ELSE 0 END
           + CASE WHEN col_6 < col_4 THEN 1 ELSE 0 END
           + CASE WHEN col_6 < col_5 THEN 1 ELSE 0 END AS r6,
           CASE WHEN col_6 = col_1 THEN 1 ELSE 0 END
           + CASE WHEN col_6 = col_2 THEN 1 ELSE 0 END
           + CASE WHEN col_6 = col_3 THEN 1 ELSE 0 END
           + CASE WHEN col_6 = col_4 THEN 1 ELSE 0 END
           + CASE WHEN col_6 = col_5 THEN 1 ELSE 0 END AS e6
    FROM   table_name
  )
)


ID
COL_1
COL_2
COL_3
COL_4


1
9
7
5
4

2
7
5
4
3

3
8
5
4
3