I have a table like in the following
col1 col2 col3 col4
1 null A 2021-04-30 14:20
1 B null 2021-04-30 14:22
1 C null 2021-04-30-14:23
2 D null 2021-04-30 14:25
2 null E 2021-04-30 14:26
I would like to query to have a result
1 C A 2021-04-30 14:27
2 D E 2021-04-30 14:28
how to write that ? using RANK / ROW_OVER ?




