AnsweredAssumed Answered

ExecuteSQL order by aggregate

Question asked by carlo.m on Oct 2, 2012
Latest reply on Oct 10, 2012 by beverly

I'm trying to order a sqlquery by an aggregate and having no luck.

 

The query:

 

Select Account, SUM(Cost)

from transactions

group by account

order by SUM(Cost)

 

the query runs fine. But it is not ordered as asked. The thing that throws me off is that it returns a result, no error. I can change the order to DESC and it runs but the order does not change at all.

 

 

Help!

Outcomes