Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: SQL QUESTION:How did correlated subquery process?
On Thu, 23 Aug 2001 20:35:46 +0800, Cantonese Boy <waynewan_at_yahoo.com>
wrote:
>If row 1 and row 2 have the same dept no, and if row 1
>is the max and got deleted , when subquery processing with
>the deptno got from the row 2, does row 1 also be counted in this
>subquery?
>
I don't think so. By then it would have been deleted, but nothing like trying? ;-)
Cheers
Nuno Souto
nsouto_at_optushome.com.au.nospam
Received on Thu Aug 23 2001 - 10:35:57 CDT