Re: HI
- From: SJHussain@xxxxxxxxxxxxxxx
- To: SrinivasT@xxxxxxxxxxxxxxx
- Date: Mon, 20 Sep 2004 09:20:26 +0300
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"
<SrinivasT@KPITCu
mmins.com> To
Sent by: <oracle-l@xxxxxxxxxxxxx>
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
--
//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 ======
--
//www.freelists.org/webpage/oracle-l
Other related posts:
