OraFAQ Forum: Training & Certification » what Sequence select statmen will execute

Home » Other » Training & Certification » what Sequence select statmen will execute (Oracle 9i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

what Sequence select statmen will execute [message #324311]

Sun, 01 June 2008 23:33

kishorebonthala
Messages: 16
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

Michel Cadot
Messages: 68641
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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 17:56:16 CDT 2024