Q: select query - I want one row to be unique

Hi,

I have this data

PRODUCT PRICE MYDATE

1       12    2001-08-01
1       13    2001-08-07
2       14    2001-08-03

I want to get a list of all the products with the latest price only (no duplicate products). I know how to do the query without the price part:

"SELECT PRODUCT, MAX(MYDATE) FROM T GROUP BY PRODUCT" works fine.

How can I include the PRICE column into the result?

/ Jacob Received on Tue Aug 07 2001 - 04:25:24 CDT