OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » precedence

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

precedence [message #576902]

Sun, 10 February 2013 06:52

ghostrider
Messages: 3
Registered: February 2013
Location: India

Junior Member

Why is it necessary to precede group by before order by and not vice versa in a sql query??
as the foll code gives an error
select name from student order by age group by name;

Report message to a moderator

Re: precedence [message #576903 is a reply to message #576902]

Sun, 10 February 2013 06:56

cookiemonster
Messages: 9169
Registered: September 2008
Location: Rainy Manchester

Senior Member

Because that's the way the people who came up with the sql standard decided it should be.

Report message to a moderator

Re: precedence [message #576904 is a reply to message #576903]

Sun, 10 February 2013 07:00

ghostrider
Messages: 3
Registered: February 2013
Location: India

Junior Member

Thankyou for your reply but there must be a reason to it when they decided to do it!!

Report message to a moderator

Re: precedence [message #576905 is a reply to message #576904]

Sun, 10 February 2013 08:25

Michel Cadot
Messages: 54226
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

The reason is that ORDER BY is NOT part of relational theory.

Regards
Michel

Report message to a moderator

Previous Topic:	what's wrong in this script
Next Topic:	PL/sql script store data

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 24 08:43:49 CDT 2013

Total time taken to generate the page: 0.15614 seconds