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 Quote 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? Quote 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 Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.