By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
5 rows affected
2 rows affected
RECORD_KEY |
---|
11 |
12 |
MACHINE_STATUS | RECORD_KEY | PR_DATE_TIME |
---|---|---|
111 | 11 | 1 |
112 | 11 | 2 |
113 | 11 | 3 |
211 | 12 | 1 |
212 | 12 | 2 |
MACHINE_STATUS | RECORD_KEY | PR_DATE_TIME |
---|---|---|
111 | 11 | 1 |
112 | 11 | 2 |
113 | 11 | 3 |
211 | 12 | 1 |
212 | 12 | 2 |
RECORD_KEY | LAST_STATUS |
---|---|
11 | 113 |
12 | 212 |