MariaDB – return 1 row of each product with 2 columns, current cost and last cost
Product Lot # Date Cost Apples 1 05/24/24 30 Apples 2 05/23/24 29 Pears 3 05/22/24 28 Pears 4 05/21/24 27 Berries 5 05/20/24 26 Berries 6 05/19/24 25 Apples 7 05/18/24 24 Apples 8 05/17/24 23 Pears 9 05/16/24 22 Pears 10 05/15/24 21 Berries 11 05/14/24 20 Berries 12 05/13/24 19 Results I […]