All Forums UDA
santosh_74 7 posts Joined 07/09
22 Jul 2009

Dear all,How to transpose the data from teradata table?I have following table structureid exam1 mar1 exa2 mark21 english 50 maths 1002 english 45 maths 90i wish to convert into id exam marks1 english 501 maths 1002 english 452 maths 90can i use bteq query to do the same?how to do it using sql?Regardssantosh

Jimm 298 posts Joined 09/07
23 Jul 2009

Select Id , exam1 As exam, mar1 as marksfrom tblUnionSelect Id, exa2, mark2Where exa2 is not nullfrom tbl;

You must sign in to leave a comment.