Jump to content

MySQL Query Help - latest distinct rows


daydreamer

Recommended Posts

A prices table will list the prices of products, and will be updated often.

 

Prices

id    product_id    qty    price    timestamp

 

Each product ID will have multiple entry's.

 

What I want to select is the newest entry's for each unique combination of 'product_id' and 'qty'.

 

How do I fit max(timestamp) in with this query:

(SELECT DISTINCT product_id, qty FROM prices)?

 

Thanks

 

 

 

 

 

Link to comment
https://forums.phpfreaks.com/topic/187136-mysql-query-help-latest-distinct-rows/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.