Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Need some query help
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