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

Report message to a moderator

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: 54200
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
In short:
from
where
group
having
order
select

Regards
Michel

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu May 23 01:27:37 CDT 2013

Total time taken to generate the page: 0.21668 seconds
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.