By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
WITH test AS (
SELECT 'a' AS col1, 2 AS col2 FROM dual UNION ALL
SELECT 'b', 3 FROM dual UNION ALL
SELECT 'c', 1 FROM dual
)
SELECT t1.col1, t1.col2, t2.col2 AS col3
FROM test t1
INNER JOIN test t2
ON t1.col2 >= t2.col2;
| COL1 | COL2 | COL3 |
|---|---|---|
| b | 3 | 3 |
| b | 3 | 2 |
| b | 3 | 1 |
| a | 2 | 2 |
| a | 2 | 1 |
| c | 1 | 1 |