From oracle-l-bounce@freelists.org Mon Sep 20 01:15:25 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i8K6FP808762 for ; Mon, 20 Sep 2004 01:15:25 -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 i8K6FPI08757 for ; Mon, 20 Sep 2004 01:15:25 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 63BBF72C3DF; Mon, 20 Sep 2004 01:21:19 -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 07185-02; Mon, 20 Sep 2004 01:21:19 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id AF66572C310; Mon, 20 Sep 2004 01:21:18 -0500 (EST) In-Reply-To: <4A1BE23A7B777442B60F4B4916AE0F130292FDF3@sohm.kpit.com> Subject: Re: HI To: SrinivasT@KPITCummins.com Cc: oracle-l@freelists.org, oracle-l-bounce@freelists.org Message-ID: From: SJHussain@alfransi.com.sa Date: Mon, 20 Sep 2004 09:20:26 +0300 X-MIMETrack: Serialize by Router on iNotes/CEN/BSF(Release 6.5.1|January 21, 2004) at 09/20/2004 09:12:39 AM MIME-Version: 1.0 Content-type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 8bit X-archive-position: 9760 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: SJHussain@alfransi.com.sa Precedence: normal Reply-To: SJHussain@alfransi.com.sa X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org It will do a filter and sort for group by caluse to get the desired group by result and then orader by will take place. Best Regards, Syed Jaffar Hussain "Srinivas T" To Sent by: oracle-l-bounce@f cc reelists.org Subject HI 09/20/2004 08:28 AM Please respond to SrinivasT@KPITCum mins.com Hi Friends, I am having a very fundamental doubt, what is the order of retrival of the clauses when all are inclueded in the select stament like. Where Group by having order by. eg : select deptno,max(sal) from emp where job like 'SAL%' group by deptno having max(sal)>1000 order by deptno Regards, Srinivas -- http://www.freelists.org/webpage/oracle-l Visit us on www.alfransi.com.sa ====== Banque Saudi Fransi - Privacy Notice ====== This message is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any use of this information by persons or entities other than the intended recipient is prohibited. If you have received this in error, please contact the sender and delete the material from your computer. Any opinions and other information contained in this message that do not relate to the official business of Banque Saudi Fransi shall be understood as neither given or endorsed by it. Although precautions have been taken to ensure no viruses are present in this email, BSF cannot accept responsibility for any loss or damage arising from the use of this email or attachments. ====== Banque Saudi Fransi - Privacy Notice ====== -- http://www.freelists.org/webpage/oracle-l