Query help. newest distinct rows.

nzo · #1 (**permalink**) 01-04-10, 12:25

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

r937 · #2 (**permalink**) 01-04-10, 12:48

Code:

SELECT product_id
     , qty 
     , MAX(timestamp) AS latest
  FROM prices
GROUP
    BY product_id
     , qty

nzo · #3 (**permalink**) 01-04-10, 13:15

awesome, thanks!

Internet Services

Web Development

Digital Marketing

Consumer Tech