Re: Q: select query - I want one row to be unique
From: ctemp <ctemp01_at_hotmail.com>
Date: 7 Aug 2001 11:53:57 -0700
Message-ID: <4d44e6cf.0108071053.33794d6d_at_posting.google.com>
Date: 7 Aug 2001 11:53:57 -0700
Message-ID: <4d44e6cf.0108071053.33794d6d_at_posting.google.com>
Just make a minor modification on your query as below.
select *
from t
where product||mydate in
(SELECT PRODUCT||MAX(MYDATE) FROM t
GROUP BY PRODUCT);
Received on Tue Aug 07 2001 - 20:53:57 CEST