Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Q: select query - I want one row to be unique
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 - 13:53:57 CDT