OraFAQ Forum: Server Administration » Using alias names in group by clause

Home » RDBMS Server » Server Administration » Using alias names in group by clause

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

Using alias names in group by clause [message #372845]

Tue, 13 March 2001 10:23

Alex
Messages: 190
Registered: August 1999

Senior Member

Hi All,

Any help will be greatly appreciated. I am trying to build a sql statement that uses alias names in the group by clause. I keep getting the error 'Invalid Column Name'. I need to have alias names in the group by because this will be a dynamic generated query, and the column names may change.

Here is the sql:
SELECT s.student_lname alias1, s.student_fname alias2, s.student_id alias3,
a.log_category alias4, count(DISTINCT a.lo_id) alias5,
min(a.log_datetime) alias6 , max(a.log_datetime) alias7 FROM access_history a,student s
WHERE ( a.student_id = s.student_id ) and s.theme_id='xyz'
group by alias1,alias2,alias3,alias4

Please help...

Thank you,

Alex

Report message to a moderator

Re: Using alias names in group by clause [message #372848 is a reply to message #372845]

Tue, 13 March 2001 15:37

Joachim Lindner
Messages: 30
Registered: February 2001

Member

Try SELECT s.student_lname AS alias1, s.student_fname AS alias2, s.student_id AS alias3, ...
It's only a guess, since I have no Oracle server available right now.

Report message to a moderator

Re: Using alias names in group by clause [message #372851 is a reply to message #372845]

Wed, 14 March 2001 02:17

waqar
Messages: 8
Registered: March 2001

Junior Member

U can't use alias in Group By clause,
but if U want to dynamically run this query then
Try This one,
Select &&column1, &&Column2, ----
Group By &Column1, &Column2, ----

Report message to a moderator

Re: Using alias names in group by clause [message #372852 is a reply to message #372845]

Wed, 14 March 2001 02:18

waqar
Messages: 8
Registered: March 2001

Junior Member

U can't use alias in Group By clause,
but if U want to dynamically run this query then
Try This one,
Select &&column1, &&Column2, ----
Group By &Column1, &Column2, ----

Report message to a moderator

Re: Using alias names in group by clause [message #372853 is a reply to message #372845]

Wed, 14 March 2001 02:20

waqar
Messages: 8
Registered: March 2001

Junior Member

U can't use alias in Group By clause,
but if U want to dynamically run this query then
Try This one,
Select &&column1, &&Column2, ----
Group By &Column1, &Column2, ----

Report message to a moderator

Re: Using alias names in group by clause [message #372854 is a reply to message #372845]

Wed, 14 March 2001 02:20

waqar
Messages: 8
Registered: March 2001

Junior Member

U can't use alias in Group By clause,
but if U want to dynamically run this query then
Try This one,
Select &&column1, &&Column2, ----
Group By &Column1, &Column2, ----

Report message to a moderator

Previous Topic:	formatting output
Next Topic:	how to create database objects & differebce between database

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jun 29 13:51:57 CDT 2024