Rank() function Selected Non Aggregated Value must be part of the associated group

Visit Teradata.com

Home

Guidelines

Member List

Welcome Guest ( Login | Register )

This online forum is for user-to-user discussions of Teradata products, and is not an official customer support channel for Teradata. If you require direct assistance, please contact Teradata support.

Rank() function Selected Non Aggregated Value...

Rate Topic

Display Mode

Topic Options

Author

Message

bad_batz

Posted 5/15/2008 1:39:40 AM

Forum Newbie

Group: Forum Members
Last Login: 5/18/2008 9:16:16 PM
Posts: 1, Visits: 6

Hi Everyone,

Was wondering if anyone could help me? I'm trying to write a query where one of the parts is to rank a "user session" based on their session_log_id, session_date and session_time

I've identified that this is the piece of code that is giving me the error

rank() over (
ORDER BY b.src_cre_time
) as SessionRank

The error i keep getting is "Selected Non Aggregated Value must be part of the associated group" which doesn't mean anything to me. I need to be able to order by this time field so that i can track the users path activity.

Can anyone help me out

many thanks

mike

Post #11442

dnoeth

Posted 5/15/2008 2:06:50 AM

Supreme Being

Group: Forum Members
Last Login: Today @ 4:54:41 PM
Posts: 534, Visits: 285

Hi Mike,
there's probably an Aggregate/GROUP BY within your query and OLAP functions are processed *after* that.

If you still need help, please post your query...

Dieter

Post #11444

« Prev Topic | Next Topic »

Reading This Topic

Active Users: 6 ( 6 guests, 0 members, 0 anonymous members )

No members currently viewing this topic.

All times are GMT -5:00, Time now is 8:50pm