add batch remove batch split batch show hidden batches hide batch
db<>fiddle
feedback about
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
version()
8.0.27
rn invno cid cname cdept idate ipaid icancel irefund l_inv_date tot_price s_tot refund billed
1 1 1 cust1 Sales 2022-01-01 2022-01-03 null null 2022-01-05 1 3 0 3
2 2 1 cust1 Sales 2022-01-03 2022-01-08 null null 2022-01-05 1 3 0 3
3 3 1 cust1 Sales 2022-01-05 2022-01-13 null null 2022-01-05 1 3 0 3
1 4 2 cust2 Sales 2022-02-01 2022-02-03 null null 2022-02-05 2 6 0 6
2 5 2 cust2 Sales 2022-02-03 2022-02-08 null null 2022-02-05 2 6 0 6
3 6 2 cust2 Sales 2022-02-05 2022-02-13 null null 2022-02-05 2 6 0 6
1 7 3 cust3 Sales 2022-03-01 null 2022-03-07 null 2022-03-14 3 9.8 0 9.8
2 8 3 cust3 Sales 2022-03-08 null 2022-03-14 null 2022-03-14 3.4 9.8 0 9.8
3 9 3 cust3 Sales 2022-03-14 null 2022-03-21 null 2022-03-14 3.4 9.8 0 9.8
1 10 4 cust4 Sales 2022-04-01 2022-04-06 2022-04-10 2022-04-22 2022-04-21 4 212.6 12.3 200.3
2 11 4 cust4 Sales 2022-04-02 2022-04-07 2022-04-12 2022-04-25 2022-04-21 4.1 212.6 12.3 200.3
3 12 4 cust4 Sales 2022-04-03 2022-04-09 2022-04-16 2022-04-28 2022-04-21 4.2 212.6 12.3 200.3
4 13 4 cust4 Sales 2022-04-20 2022-04-27 null null 2022-04-21 100.1 212.6 12.3 200.3
5 14 4 cust4 Sales 2022-04-21 2022-04-29 null null 2022-04-21 100.2 212.6 12.3 200.3
1 null 5 cust5 Sales null null null null null 0 null null null
cid cname inv_count l_inv_date s_tot refund valid_billed
1 cust1 3 2022-01-05 3 0 3
2 cust2 3 2022-02-05 6 0 6
3 cust3 3 2022-03-14 9.8 0 9.8
4 cust4 5 2022-04-21 212.6 12.3 200.3
5 cust5 0 null 0 0 0