Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Q: select query - I want one row to be unique

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@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 - 13:53:57 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US