daydreamer Posted January 4, 2010 Share Posted January 4, 2010 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 More sharing options...
fenway Posted January 6, 2010 Share Posted January 6, 2010 I assume you solved this with a GROUP BY? Link to comment https://forums.phpfreaks.com/topic/187136-mysql-query-help-latest-distinct-rows/#findComment-989546 Share on other sites More sharing options...
daydreamer Posted January 7, 2010 Author Share Posted January 7, 2010 yeh Link to comment https://forums.phpfreaks.com/topic/187136-mysql-query-help-latest-distinct-rows/#findComment-990629 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.