I want to transpose few rows into columns in teradata. please help me writing the SQL.
Output -- A B C
. i have tried a lot but counldn't find a solution.Please reply as soon as possible.
Try with select tdstats.udfconcat(input1) from yourtable; You can remove the unwanted " and , using regexp_replace....
I am not getting your point , i am new to teradata. Can you please explain more. thanks for the reply though.
Maybe this example can help you: