add batch remove batch split batch comment selection show hidden batches hide batch highlight batch
db<>fiddle
donate feedback about
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
id
151
152
153
id id_mkd
9883 152
9884 152
9886 152
id_contragent period h hw
9883 2019-12-01 217.3 0
9884 2019-12-01 5349.3 0
9886 2019-12-01 8269.42 0
id_contragent date_from period debt
9883 null null null
9884 2019-10-23 2019-10-01 4120.96
9886 2019-10-23 2019-10-01 6370.54
id id_contragent date_from period debt_sum_h debt_sum_hw
1 9883 null null null null
2 9884 2019-11-02 2019-11-01 11111.11 0
3 9884 2019-11-03 2019-11-01 222.22 0
4 9884 2019-11-01 2019-11-01 3.3 0
5 9886 null null null null
id id_contragent date_from period debt_sum_h debt_sum_hw
1 9883 null null null null
2 9884 2019-11-12 2019-11-01 12271.17 0
3 9884 2019-12-20 2019-12-01 10140.7 0
4 9884 2019-11-13 2019-11-01 6588.87 0
5 9884 2019-11-11 2019-11-01 4262.19 0
6 9886 null null null null
rn id dhhw n_df n_debt x_df x_debt t_df t_debt
1 9883 217.3 null null null null null null
1 9884 5349.3 2019-10-23 4120.96 2019-11-01 3.3 2019-11-11 4262.19
2 9884 null null null 2019-11-02 11111.11 2019-11-12 12271.17
3 9884 null null null 2019-11-03 222.22 2019-11-13 6588.87
4 9884 null null null null null 2019-12-20 10140.7
1 9886 8269.42 2019-10-23 6370.54 null null null null