3706 error on Qualify code

General
N/A

3706 error on Qualify code

Can anyone please help me with this error. This code has worked fine for over a year then we upgraded teradata and now it no longer works (no other changes). Im new to Teradata so any help would be much appreciated

Qualify Row_Number() Over (Partition by URN Order by hierarchy asc) = 1;

3706: Syntax error: expected something between the 'QUALIFY' keyword and ';'

thanks
1 REPLY
Junior Supporter

Re: 3706 error on Qualify code

Please, post the ENTIRE SQL sentence (the show table is desirable too)

Cheers.

Carlos.