By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
scdate | value |
---|---|
2021-11-10 17:00:00 | 1943.98 |
2021-11-10 17:00:18 | 1957.13 |
2021-11-10 17:00:36 | 1953.94 |
2021-11-10 17:00:54 | 1946.28 |
2021-11-10 17:01:12 | 1960.29 |
2021-11-10 17:01:29 | 1950.39 |
2021-11-10 17:01:47 | 1942.62 |
2021-11-10 17:02:05 | 1954.64 |
2021-11-10 17:02:23 | 1958.21 |
2021-11-10 17:02:41 | 1950.26 |
2021-11-10 17:02:58 | 1945.33 |
2021-11-10 17:03:16 | 1960.35 |
2021-11-10 17:04:33 | null |
scdate | value | value | value | TempCount |
---|---|---|---|---|
2021-11-10 17:00:00 | 1943.98 | 1957.13 | 1953.94 | 2 |
2021-11-10 17:00:18 | 1957.13 | 1953.94 | 1946.28 | 3 |
2021-11-10 17:00:36 | 1953.94 | 1946.28 | 1960.29 | 3 |
2021-11-10 17:00:54 | 1946.28 | 1960.29 | 1950.39 | 3 |
2021-11-10 17:01:12 | 1960.29 | 1950.39 | 1942.62 | 2 |
2021-11-10 17:01:29 | 1950.39 | 1942.62 | 1954.64 | 2 |
2021-11-10 17:01:47 | 1942.62 | 1954.64 | 1958.21 | 2 |
2021-11-10 17:02:05 | 1954.64 | 1958.21 | 1950.26 | 3 |
2021-11-10 17:02:23 | 1958.21 | 1950.26 | 1945.33 | 3 |
2021-11-10 17:02:41 | 1950.26 | 1945.33 | 1960.35 | 3 |
2021-11-10 17:02:58 | 1945.33 | 1960.35 | null | 2 |
2021-11-10 17:03:16 | 1960.35 | null | null | 1 |
2021-11-10 17:04:33 | null | null | null | 0 |