Archives of the TeradataForum

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

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

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>>