I have a database for a shop with date+time stamps of when items were purchased, I'd like to find the value of the last item that was purchased across multiple products.
How do I go about this?
Tried below but it's not working for me
Select product_id, price
order_at = (SELECT max(order_at) FROM Fruitshop)
I also tried