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: Need some query help

Re: Need some query help

From: Rishi Dhupar <rishid_at_gmail.com>
Date: 27 Feb 2006 09:20:27 -0800
Message-ID: <1141060827.153691.156420@i40g2000cwc.googlegroups.com>


Not exactly sure what you wrote there, but I am using Oracle 73

something I came up, the select statement is returning what I want, I just need to figure out how to set all the IRD columns to 1 for all the returning rows.

Below is not working, but I believe it should.

UPDATE (SELECT FLIGHTTEST,DOCNAME, IRD, MIN(DOCDATE) FROM DT_DATA GROUP BY FLIGHTTEST, DOCNAME, IRD) SET IRD = '1' Received on Mon Feb 27 2006 - 11:20:27 CST

Original text of this message

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