By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| IdCx | FecCx | FecTest | Resultado |
|---|---|---|---|
| 1234 | 2023-01-04 17:00:00.000 | 2023-01-02 12:00:00.000 | 0.3 |
| 1234 | 2023-01-04 17:00:00.000 | 2023-01-03 17:00:00.000 | 0.4 |
| 1234 | 2023-01-04 17:00:00.000 | 2023-01-04 19:00:00.000 | 0.4 |
| 1234 | 2023-01-04 17:00:00.000 | 2023-01-04 23:00:00.000 | 0.4 |
| 1234 | 2023-01-04 17:00:00.000 | 2023-01-05 05:00:00.000 | 0.6 |
| IdCx | FecCx | FecTest | Resultado | Order |
|---|---|---|---|---|
| 1234 | 2023-01-04 17:00:00.000 | 2023-01-03 17:00:00.000 | 0.4 | -1 |
| 1234 | 2023-01-04 17:00:00.000 | 2023-01-02 12:00:00.000 | 0.3 | -2 |
| 1234 | 2023-01-04 17:00:00.000 | 2023-01-04 19:00:00.000 | 0.4 | 1 |
| 1234 | 2023-01-04 17:00:00.000 | 2023-01-04 23:00:00.000 | 0.4 | 2 |
| 1234 | 2023-01-04 17:00:00.000 | 2023-01-05 05:00:00.000 | 0.6 | 3 |