By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
70 rows affected
clientid | invoiceid | invoicedate | documentdate |
---|---|---|---|
18924 | 2819 | 2019-01-17 | 2019-01-12 |
18924 | 4524 | 2019-01-15 | 2019-01-12 |
18924 | 9897 | 2018-12-31 | null |
18924 | 1591 | 2018-12-25 | null |
27113 | 5808 | 2020-10-16 | 2020-10-14 |
27113 | 4359 | 2020-10-11 | 2020-09-25 |
27113 | 3405 | 2020-10-01 | 2020-09-25 |
27113 | 9889 | 2020-09-21 | 2020-09-11 |
27113 | 1976 | 2020-09-19 | 2020-09-11 |
30487 | 8598 | 2020-06-02 | 2020-03-29 |
30487 | 2492 | 2020-05-15 | 2020-03-29 |
30487 | 1809 | 2020-04-16 | 2020-03-29 |
30487 | 6765 | 2020-04-11 | 2020-03-29 |
30487 | 1940 | 2020-02-19 | null |
37699 | 1060 | 2020-11-27 | 2020-10-20 |
37699 | 1228 | 2020-10-03 | 2020-09-15 |
37699 | 8596 | 2020-09-27 | 2020-09-15 |
37699 | 4931 | 2020-07-31 | null |
37699 | 7836 | 2020-07-16 | null |
53369 | 9650 | 2020-08-13 | 2020-08-10 |
53369 | 5402 | 2020-08-11 | 2020-08-10 |
53369 | 6845 | 2020-06-30 | 2020-06-17 |
86159 | 3637 | 2019-12-05 | 2019-09-16 |
86159 | 8560 | 2019-11-28 | 2019-09-16 |
86159 | 6643 | 2019-10-06 | 2019-09-16 |
86159 | 2989 | 2019-09-04 | 2019-08-21 |
92122 | 7960 | 2020-11-23 | 2020-08-18 |
92122 | 9596 | 2020-11-06 | 2020-08-18 |
92122 | 3429 | 2020-09-09 | 2020-08-18 |
92122 | 6773 | 2020-08-30 | 2020-08-18 |
92122 | 5147 | 2020-07-05 | null |
93781 | 8876 | 2021-11-26 | 2021-11-19 |
93781 | 8409 | 2021-11-18 | 2021-10-29 |
93781 | 7252 | 2021-11-04 | 2021-10-29 |
93781 | 4169 | 2021-10-08 | null |
93781 | 2205 | 2021-10-02 | null |
Warning: Null value is eliminated by an aggregate or other SET operation.
clientid | invoiceid | invoicedate | InvoiceRank | documentid | documentdate | DocumentRank |
---|---|---|---|---|---|---|
18924 | 2819 | 2019-01-17 | 1 | 9979 | 2019-01-12 | 1 |
18924 | 4524 | 2019-01-15 | 2 | 8913 | 2019-01-06 | 2 |
18924 | 9897 | 2018-12-31 | 3 | null | null | 4 |
18924 | 1591 | 2018-12-25 | 4 | null | null | 4 |
27113 | 5808 | 2020-10-16 | 1 | 9533 | 2020-10-14 | 1 |
27113 | 3405 | 2020-10-01 | 3 | 9521 | 2020-09-25 | 3 |
27113 | 9889 | 2020-09-21 | 4 | 8680 | 2020-09-11 | 4 |
27113 | 1976 | 2020-09-19 | 5 | 3504 | 2020-09-03 | 5 |
30487 | 8598 | 2020-06-02 | 1 | 6049 | 2020-03-29 | 1 |
30487 | 2492 | 2020-05-15 | 2 | 3084 | 2020-03-25 | 2 |
30487 | 1809 | 2020-04-16 | 3 | 8230 | 2020-03-19 | 3 |
30487 | 6765 | 2020-04-11 | 4 | 6556 | 2020-03-18 | 4 |
30487 | 1940 | 2020-02-19 | 5 | null | null | 5 |
37699 | 1060 | 2020-11-27 | 1 | 1897 | 2020-10-20 | 1 |
37699 | 1228 | 2020-10-03 | 2 | 4277 | 2020-09-15 | 2 |
37699 | 4931 | 2020-07-31 | 4 | null | null | 3 |
37699 | 7836 | 2020-07-16 | 5 | null | null | 3 |
53369 | 9650 | 2020-08-13 | 1 | 2752 | 2020-08-10 | 1 |
53369 | 5402 | 2020-08-11 | 2 | 9141 | 2020-08-05 | 2 |
53369 | 6845 | 2020-06-30 | 3 | 1712 | 2020-06-17 | 3 |
86159 | 3637 | 2019-12-05 | 1 | 6180 | 2019-09-16 | 1 |
86159 | 8560 | 2019-11-28 | 2 | 7372 | 2019-08-21 | 2 |
86159 | 6643 | 2019-10-06 | 3 | 9438 | 2019-08-14 | 3 |
92122 | 7960 | 2020-11-23 | 1 | 1487 | 2020-08-18 | 1 |
92122 | 9596 | 2020-11-06 | 2 | 3214 | 2020-08-13 | 2 |
92122 | 3429 | 2020-09-09 | 3 | 2661 | 2020-07-29 | 3 |
92122 | 5147 | 2020-07-05 | 5 | null | null | 4 |
93781 | 8876 | 2021-11-26 | 1 | 8537 | 2021-11-19 | 1 |
93781 | 8409 | 2021-11-18 | 2 | 4042 | 2021-10-29 | 2 |
93781 | 7252 | 2021-11-04 | 3 | 5847 | 2021-10-13 | 3 |
93781 | 4169 | 2021-10-08 | 4 | null | null | 4 |
93781 | 2205 | 2021-10-02 | 5 | null | null | 4 |