Home » SQL & PL/SQL » SQL & PL/SQL » group by expression
group by expression [message #7058] Mon, 19 May 2003 06:39 Go to next message
ARANGASWAMY.V.
Messages: 29
Registered: April 2002
Junior Member
When we use order by expression it is enough to indicate the number in stead of column name itself (eg. order by desc 3)

Why it is not so for group by expression.

Or is there any method (shortcut) for this.
kindly enlighten me

thanks

Report message to a moderator

Re: group by expression [message #7072 is a reply to message #7058] Tue, 20 May 2003 00:22 Go to previous message
Maaher
Messages: 7065
Registered: December 2001
Senior Member
There's no shortcut in my knowledge, you'll have to group by an expression of your select list or a column from any of the tables in the From clause. Even a column alias won't be accepted (at least not in our 8i environment).

MHE

Report message to a moderator

Previous Topic: need to open file in one package and write to it from another
Next Topic: Export Tables
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 26 00:34:07 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.