Archives of the TeradataForum
Message Posted: Wed, 23 Feb 2011 @ 12:38:54 GMT
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
Please provide your inputs if you are aware of this issue and the fix.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 15 Jun 2023|