From oracle-l-bounce@freelists.org Mon Sep 20 09:39:27 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i8KEdOM26096 for ; Mon, 20 Sep 2004 09:39:24 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i8KEdOI26091 for ; Mon, 20 Sep 2004 09:39:24 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id AEAE372CBD6; Mon, 20 Sep 2004 09:45:24 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 30351-82; Mon, 20 Sep 2004 09:45:24 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 22E5672C7B0; Mon, 20 Sep 2004 09:45:24 -0500 (EST) Message-ID: Date: Mon, 20 Sep 2004 07:43:52 -0700 From: Jared Still To: mrichard@transurban.com.au Subject: Re: HI Cc: srinivast@kpitcummins.com, oracle-l@freelists.org In-Reply-To: Mime-Version: 1.0 Content-type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 8bit References: X-archive-position: 9772 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: jkstill@gmail.com Precedence: normal Reply-To: jkstill@gmail.com X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org On Mon, 20 Sep 2004 15:41:34 +1000, Mark Richard wrote: > > The where clause must be processed first - since it removes atomic records > of data. Next the group by has to be applied to determine the values of > max(sal). This allows the having clause to be applied (which I tend to > think of as "where clauses applied after group by"). Finally the order by > can be applied to ensure the result set appears in the desired order. > After recent discussions on this list regarding nested sub-queries, don't assume that Oracle will always process the WHERE clause first. (Check the archives ) The simple query in the previous post won't be a problem, but it is nonetheless a dangerous assumption. Jonathan Gennick where are you? - care to comment? Jared -- http://www.freelists.org/webpage/oracle-l