Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 23 Feb 2011 @ 12:38:54 GMT


     
  <Prev Next>   <<First <Prev
Next>
Last>>
 


Subj:   Re: Error expected something between QUALIFY keyword and ';'
 
From:   Jepamony, Johnpaul

Bingo!

We too faced similar issue after the upgrade. This could be a fault from any driver, ODBC, SQLA or a bug in new TD.

You can try the below query.

     SELECT *
     FROM  DB.TL
     GROUP BY 1,2,3,4
     QUALIFY ROW_NUMBER() OVER( PARTITION BY COL1,COL2,COL3,C0L4
        ORDER BY COL1,COL2,COL3,C0L4  )= 1

Experts-

Please provide your inputs if you are aware of this issue and the fix.


Cheers

John



     
  <Prev Next>   <<First <Prev
Next>
Last>>
 
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023