By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
6 rows affected
F1 | F2 | F3 | F4 |
---|---|---|---|
2019-12-13 | A | 存款 | 300 |
2019-12-13 | A | 應收款項 | 500 |
2019-12-13 | A | 應付帳款 | 200 |
2019-12-13 | B | 存款 | 200 |
2019-12-13 | B | 應付帳款 | 100 |
2019-12-13 | C | 應收款項 | 600 |
180 rows affected
F1 | F2 | F3 | F4 |
---|---|---|---|
2019-12-13 | A | 存款 | 300 |
2019-12-13 | A | 應付帳款 | 200 |
2019-12-13 | A | 應收款項 | 500 |
2019-12-13 | B | 存款 | 200 |
2019-12-13 | B | 應付帳款 | 100 |
2019-12-13 | C | 應收款項 | 600 |
2019-12-14 | A | 存款 | 300 |
2019-12-14 | A | 應付帳款 | 200 |
2019-12-14 | A | 應收款項 | 500 |
2019-12-14 | B | 存款 | 200 |
2019-12-14 | B | 應付帳款 | 100 |
2019-12-14 | C | 應收款項 | 600 |
2019-12-15 | A | 存款 | 300 |
2019-12-15 | A | 應付帳款 | 200 |
2019-12-15 | A | 應收款項 | 500 |
2019-12-15 | B | 存款 | 200 |
2019-12-15 | B | 應付帳款 | 100 |
2019-12-15 | C | 應收款項 | 600 |
2019-12-16 | A | 存款 | 300 |
2019-12-16 | A | 應付帳款 | 200 |
2019-12-16 | A | 應收款項 | 500 |
2019-12-16 | B | 存款 | 200 |
2019-12-16 | B | 應付帳款 | 100 |
2019-12-16 | C | 應收款項 | 600 |
2019-12-17 | A | 存款 | 300 |
2019-12-17 | A | 應付帳款 | 200 |
2019-12-17 | A | 應收款項 | 500 |
2019-12-17 | B | 存款 | 200 |
2019-12-17 | B | 應付帳款 | 100 |
2019-12-17 | C | 應收款項 | 600 |
2019-12-18 | A | 存款 | 300 |
2019-12-18 | A | 應付帳款 | 200 |
2019-12-18 | A | 應收款項 | 500 |
2019-12-18 | B | 存款 | 200 |
2019-12-18 | B | 應付帳款 | 100 |
2019-12-18 | C | 應收款項 | 600 |
2019-12-19 | A | 存款 | 300 |
2019-12-19 | A | 應付帳款 | 200 |
2019-12-19 | A | 應收款項 | 500 |
2019-12-19 | B | 存款 | 200 |
2019-12-19 | B | 應付帳款 | 100 |
2019-12-19 | C | 應收款項 | 600 |
2019-12-20 | A | 存款 | 300 |
2019-12-20 | A | 應付帳款 | 200 |
2019-12-20 | A | 應收款項 | 500 |
2019-12-20 | B | 存款 | 200 |
2019-12-20 | B | 應付帳款 | 100 |
2019-12-20 | C | 應收款項 | 600 |
2019-12-21 | A | 存款 | 300 |
2019-12-21 | A | 應付帳款 | 200 |
2019-12-21 | A | 應收款項 | 500 |
2019-12-21 | B | 存款 | 200 |
2019-12-21 | B | 應付帳款 | 100 |
2019-12-21 | C | 應收款項 | 600 |
2019-12-22 | A | 存款 | 300 |
2019-12-22 | A | 應付帳款 | 200 |
2019-12-22 | A | 應收款項 | 500 |
2019-12-22 | B | 存款 | 200 |
2019-12-22 | B | 應付帳款 | 100 |
2019-12-22 | C | 應收款項 | 600 |
2019-12-23 | A | 存款 | 300 |
2019-12-23 | A | 應付帳款 | 200 |
2019-12-23 | A | 應收款項 | 500 |
2019-12-23 | B | 存款 | 200 |
2019-12-23 | B | 應付帳款 | 100 |
2019-12-23 | C | 應收款項 | 600 |
2019-12-24 | A | 存款 | 300 |
2019-12-24 | A | 應付帳款 | 200 |
2019-12-24 | A | 應收款項 | 500 |
2019-12-24 | B | 存款 | 200 |
2019-12-24 | B | 應付帳款 | 100 |
2019-12-24 | C | 應收款項 | 600 |
2019-12-25 | A | 存款 | 300 |
2019-12-25 | A | 應付帳款 | 200 |
2019-12-25 | A | 應收款項 | 500 |
2019-12-25 | B | 存款 | 200 |
2019-12-25 | B | 應付帳款 | 100 |
2019-12-25 | C | 應收款項 | 600 |
2019-12-26 | A | 存款 | 300 |
2019-12-26 | A | 應付帳款 | 200 |
2019-12-26 | A | 應收款項 | 500 |
2019-12-26 | B | 存款 | 200 |
2019-12-26 | B | 應付帳款 | 100 |
2019-12-26 | C | 應收款項 | 600 |
2019-12-27 | A | 存款 | 300 |
2019-12-27 | A | 應付帳款 | 200 |
2019-12-27 | A | 應收款項 | 500 |
2019-12-27 | B | 存款 | 200 |
2019-12-27 | B | 應付帳款 | 100 |
2019-12-27 | C | 應收款項 | 600 |
2019-12-28 | A | 存款 | 300 |
2019-12-28 | A | 應付帳款 | 200 |
2019-12-28 | A | 應收款項 | 500 |
2019-12-28 | B | 存款 | 200 |
2019-12-28 | B | 應付帳款 | 100 |
2019-12-28 | C | 應收款項 | 600 |
2019-12-29 | A | 存款 | 300 |
2019-12-29 | A | 應付帳款 | 200 |
2019-12-29 | A | 應收款項 | 500 |
2019-12-29 | B | 存款 | 200 |
2019-12-29 | B | 應付帳款 | 100 |
2019-12-29 | C | 應收款項 | 600 |
2019-12-30 | A | 存款 | 300 |
2019-12-30 | A | 應付帳款 | 200 |
2019-12-30 | A | 應收款項 | 500 |
2019-12-30 | B | 存款 | 200 |
2019-12-30 | B | 應付帳款 | 100 |
2019-12-30 | C | 應收款項 | 600 |
2019-12-31 | A | 存款 | 300 |
2019-12-31 | A | 應付帳款 | 200 |
2019-12-31 | A | 應收款項 | 500 |
2019-12-31 | B | 存款 | 200 |
2019-12-31 | B | 應付帳款 | 100 |
2019-12-31 | C | 應收款項 | 600 |
2020-01-01 | A | 存款 | 300 |
2020-01-01 | A | 應付帳款 | 200 |
2020-01-01 | A | 應收款項 | 500 |
2020-01-01 | B | 存款 | 200 |
2020-01-01 | B | 應付帳款 | 100 |
2020-01-01 | C | 應收款項 | 600 |
2020-01-02 | A | 存款 | 300 |
2020-01-02 | A | 應付帳款 | 200 |
2020-01-02 | A | 應收款項 | 500 |
2020-01-02 | B | 存款 | 200 |
2020-01-02 | B | 應付帳款 | 100 |
2020-01-02 | C | 應收款項 | 600 |
2020-01-03 | A | 存款 | 300 |
2020-01-03 | A | 應付帳款 | 200 |
2020-01-03 | A | 應收款項 | 500 |
2020-01-03 | B | 存款 | 200 |
2020-01-03 | B | 應付帳款 | 100 |
2020-01-03 | C | 應收款項 | 600 |
2020-01-04 | A | 存款 | 300 |
2020-01-04 | A | 應付帳款 | 200 |
2020-01-04 | A | 應收款項 | 500 |
2020-01-04 | B | 存款 | 200 |
2020-01-04 | B | 應付帳款 | 100 |
2020-01-04 | C | 應收款項 | 600 |
2020-01-05 | A | 存款 | 300 |
2020-01-05 | A | 應付帳款 | 200 |
2020-01-05 | A | 應收款項 | 500 |
2020-01-05 | B | 存款 | 200 |
2020-01-05 | B | 應付帳款 | 100 |
2020-01-05 | C | 應收款項 | 600 |
2020-01-06 | A | 存款 | 300 |
2020-01-06 | A | 應付帳款 | 200 |
2020-01-06 | A | 應收款項 | 500 |
2020-01-06 | B | 存款 | 200 |
2020-01-06 | B | 應付帳款 | 100 |
2020-01-06 | C | 應收款項 | 600 |
2020-01-07 | A | 存款 | 300 |
2020-01-07 | A | 應付帳款 | 200 |
2020-01-07 | A | 應收款項 | 500 |
2020-01-07 | B | 存款 | 200 |
2020-01-07 | B | 應付帳款 | 100 |
2020-01-07 | C | 應收款項 | 600 |
2020-01-08 | A | 存款 | 300 |
2020-01-08 | A | 應付帳款 | 200 |
2020-01-08 | A | 應收款項 | 500 |
2020-01-08 | B | 存款 | 200 |
2020-01-08 | B | 應付帳款 | 100 |
2020-01-08 | C | 應收款項 | 600 |
2020-01-09 | A | 存款 | 300 |
2020-01-09 | A | 應付帳款 | 200 |
2020-01-09 | A | 應收款項 | 500 |
2020-01-09 | B | 存款 | 200 |
2020-01-09 | B | 應付帳款 | 100 |
2020-01-09 | C | 應收款項 | 600 |
2020-01-10 | A | 存款 | 300 |
2020-01-10 | A | 應付帳款 | 200 |
2020-01-10 | A | 應收款項 | 500 |
2020-01-10 | B | 存款 | 200 |
2020-01-10 | B | 應付帳款 | 100 |
2020-01-10 | C | 應收款項 | 600 |
2020-01-11 | A | 存款 | 300 |
2020-01-11 | A | 應付帳款 | 200 |
2020-01-11 | A | 應收款項 | 500 |
2020-01-11 | B | 存款 | 200 |
2020-01-11 | B | 應付帳款 | 100 |
2020-01-11 | C | 應收款項 | 600 |
2020-01-12 | A | 存款 | 300 |
2020-01-12 | A | 應付帳款 | 200 |
2020-01-12 | A | 應收款項 | 500 |
2020-01-12 | B | 存款 | 200 |
2020-01-12 | B | 應付帳款 | 100 |
2020-01-12 | C | 應收款項 | 600 |