Say I have a Delivery table and I want to get the last record of each item, Is there a query I could run to get that?
Say I have a Delivery table and I want to get the last record of each item, Is there a query I could run to get that?
Please post your db structure as your question isn’t clear. Do you mean you have a delivery table with a related delivery_item table?
There is an items table and a delivery table. The delivery table has the delivery of various items. I want to get the last delivery of each item to show at all times instead of the multiple deliveries of the same item. A sample of the fields in the table is below.
Delivery(id, batch, item_id, quantity)
Item (id, name, brand)