Archives of the TeradataForum
Message Posted: Thu, 05 Jul 2001 @ 10:24:24 GMT
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?
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|