I have a table of Repair Orders, and each Repair Order has a Sale Column with the total Sales for the Repair Order. What would be the best way to get a Grand Total of all the sales? Should I create a separate table with a virtual column? My end goal ...

How can I filter a table of records and show the most recent of each unique one? My table is made up of a log of repair orders by date, and I would like to filter by only the most recent ones. So basically, out of 100 rows there could be several reco...