Teradata SQL and Nested Functions

[jakeH]

My company has just upgraded to v2r5 and a user has hit a snag with a query they're running which has the following line of sql

count(sum(PRD_BO_CCM_VIEWS.ROCK_EVT_AGNT_ACTVY.DGT_DIAL))

Teradata flags this as an error as it logically cannot nest aggregate functions.

However, if Teradata could run this, would the result always be 1? Is this correct?

 

[dnoeth]

This has nothing to do with your upgrade, every Teradata version returns that error message.

You have to use Derived Tables:
select
count(*)
from
(select
sum(PRD_BO_CCM_VIEWS.ROCK_EVT_AGNT_ACTVY.DGT_DIAL) as x
from table
) dt


"However, if Teradata could run this, would the result always be 1? Is this correct?"

Who knows?
This might be:
select
count(sum(PRD_BO_CCM_VIEWS.ROCK_EVT_AGNT_ACTVY.DGT_DIAL))
from table
group by columnx

Btw, does any other DBMS return a result?

Dieter