By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
4 rows affected
TIME_COL | LENGTH_COL | NAME_COL | RNK |
---|---|---|---|
00:01:00 | 2 | a | 1 |
00:11:22 | 2 | a | 2 |
01:01:00 | 45 | a | 3 |
00:23:00 | 3 | b | 1 |
RNK | A_TIME_COL | A_LENGTH_COL | B_TIME_COL | B_LENGTH_COL |
---|---|---|---|---|
2 | 00:11:22 | 2 | null | null |
3 | 01:01:00 | 45 | null | null |
1 | 00:01:00 | 2 | 00:23:00 | 3 |
A_TIME_COL | A_LENGTH_COL | B_TIME_COL | B_LENGTH_COL |
---|---|---|---|
00:11:22 | 2 | null | null |
01:01:00 | 45 | null | null |
00:01:00 | 2 | 00:23:00 | 3 |
TIME_COL_A | LENGTH_COL_A | TIME_COL_B | LENGTH_COL_B |
---|---|---|---|
00:01:00 | 2 | 00:23:00 | 3 |
00:11:22 | 2 | null | null |
01:01:00 | 45 | null | null |
ORA-00904: "T": invalid identifier