By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
id1 | id2 | mark | type | time | update | Обновлять? |
---|---|---|---|---|---|---|
10001 | 4 | 10090 | 2 | 2019-12-25 11:01:00 | 0 | yes |
10001 | 7 | 10090 | 2 | 2019-12-25 11:04:00 | 0 | yes |
10001 | 9 | 10090 | 2 | 2019-12-25 11:06:00 | 0 | no |
10001 | 2 | 10090 | 2 | 2019-12-25 12:00:01 | 0 | no |
20002 | 1 | 10090 | 2 | 2019-12-25 12:11:00 | 0 | no |
10001 | 5 | 10091 | 2 | 2019-12-25 11:02:00 | 0 | yes |
20002 | 3 | 20090 | 2 | 2019-12-25 12:13:00 | 0 | yes |
20002 | 4 | 20091 | 2 | 2019-12-25 12:14:00 | 0 | yes |
20002 | 5 | 20092 | 2 | 2019-12-25 12:15:00 | 0 | yes |
30090 | 7 | 31090 | 2 | 2019-12-25 11:00:00 | 0 | yes |
40090 | 5 | 41090 | 2 | 2019-12-25 11:00:00 | 0 | yes |