All Forums General
Purushotham 87 posts Joined 04/14
08 Jun 2014
To convert rows into columns in teradata

Hi,

I have a query that,to convert rows into columns can we use decode or pivot to convert rows into columns in Teradata .

Pls give the syntax that would helpful to me...

Purushotham.M
Raja_KT 1246 posts Joined 07/09
09 Jun 2014

It would be good if you can share what you have and what do you expect.  You can refer to some links here like:
http://forums.teradata.com/forum/general/teradata-pivot-function-equivalence-of-oracle-or-sql-server-pivot-function-in-teradata#comment-133417
http://forums.teradata.com/forum/database/concatenate-and-aggregate-row-values-to-columns#comment-133720
ans few more.....

Raja K Thaw
My wiki: http://en.wikipedia.org/wiki/User:Kt_raj1
Street Children suffer not by their fault. We can help them if we want.

You must sign in to leave a comment.