Home » Other » Training & Certification » what Sequence select statmen will execute (Oracle 9i)
what Sequence select statmen will execute [message #324311] Sun, 01 June 2008 23:33 Go to next message
kishorebonthala
Messages: 15
Registered: May 2008
Location: Bangalore
Junior Member

Hi,

I want to know in what sequence this select statement will execute.

SELECT col1,col2,
FROM TABLE
WHERE <condition>
group by col1,
having <group restriction>
order by col1;

Regards,
Kishore
Re: what Sequence select statmen will execute [message #324321 is a reply to message #324311] Mon, 02 June 2008 00:24 Go to previous message
Michel Cadot
Messages: 58597
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
In short:
from
where
group
having
order
select

Regards
Michel
Previous Topic: using alter command
Next Topic: 256 th day in the year
Goto Forum:
  


Current Time: Mon Jul 28 00:34:09 CDT 2014

Total time taken to generate the page: 0.07009 seconds