Archives of the TeradataForum
Message Posted: Thu, 05 Jul 2001 @ 10:24:24 GMT
Subj: | | Stat functions in subqueries |
|
From: | | Stuart MacMillan |
Has anyone come against this problem?
Running code on V2R4 for the first time having just moved from V2R3 I'm experiencing
*** Failure 5604 STAT FUNCTIONS not allowed in Subqueries.
The code fragment is
...
not in (select
col_list
from
(sel * from
table_1
group by col_1,col_2
qualify rank(col_3) = 1
) as temp
)
This has run since Oct 2000 under V2R3 so my question is why did it work in the first place?
|