All Forums General
ea6igo 1 post Joined 08/10
19 Aug 2010
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

CarlosAL 512 posts Joined 04/08
20 Aug 2010

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

Cheers.

Carlos.

You must sign in to leave a comment.