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: help with comparing dates and deleteing oldest

Re: help with comparing dates and deleteing oldest

From: <ak_tiredofspam_at_yahoo.com>
Date: 4 Mar 2005 12:25:35 -0800
Message-ID: <1109967935.352003.58460@l41g2000cwc.googlegroups.com> 





delete from assoc a


where exists(select 1 from dbassoc b


where a.dbassoc = b.dbassoc


and trunc(a.dbdate) = trunc(b.dbdate) 


and a.dbdate < b.dbdate)
Received on Fri Mar 04 2005 - 14:25:35 CST












Original text of this message













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