Q: select query - I want one row to be unique
From: Jacob Nordgren <jacob_nordgren_at_hotmail.com>
Date: 7 Aug 2001 02:25:24 -0700
Message-ID: <47c6b9be.0108070125.21f353e0_at_posting.google.com>
Date: 7 Aug 2001 02:25:24 -0700
Message-ID: <47c6b9be.0108070125.21f353e0_at_posting.google.com>
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 - 11:25:24 CEST