Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Derived Column with Rank and Qualify
al1024 \ thanks a lot. Your fix looks excellent. I try to run it, but teradata gives me a 'expecting something like a UDFCALLNAME keyword error between the ) and ORDER. So now I need to work that out. Also, I changed the name of the first column from ROW_ONE to COLUMN_ONE and tried adding...- Novs
- Post #3
- Forum: NCR: Teradata
-
Derived Column with Rank and Qualify
I am using teradata. This is what I want to do: SELECT 'Total ' as Row_One , Name , Sum (Column2) Column2_Sum , Sum (Column3) Column3_Sum , Sum (Column4) Column4_Sum , (Column2_Sum + Column3_Sum + Column4_Sum) Total_Sum , Rank (Total_Sum) Total_Sum_Rank FROM [table] GROUP BY Name...- Novs
- Thread
- Replies: 3
- Forum: NCR: Teradata
