InstantForum.NET v4.1.4Teradata Forumshttp://www.teradata.com/teradataforum/info@teradata.comThu, 28 Aug 2008 21:17:16 GMT20http://www.teradata.com/teradataforum/Topic11243-22-1.aspxHi Satya,Try with the following query…Select carrier, sum(first_reason_cde), sum(first_qty), sum(second_reas_cde), sum(second_qty), sum(third_reas_cde), sum(third_qty) from table_name group by 1Regards,BalamuruganThu, 17 Apr 2008 03:20:06 GMTBalamurugan Bhttp://www.teradata.com/teradataforum/Topic11243-22-1.aspxI have a table with following data: carrier first_reason_cde first_qty second_reas_cde second_qty third_reas_cde third_qty111 10 2 0 0 0 0111 0 0 11 1 0 0111 0 0 0 0 11 2222 0 0 12 4 0 0222 11 1 0 0 0 0222 0 0 0 0 13 4so on ----- --- --- --- -- ---- --- Desired Output: carrier first_reason_cde first_qty second_reas_cde second_qty third_reas_cde third_qty111 10 2 11 1 11 2222 11 1 12 4 13 4---- ----------- -- ------------------THANKSSATYAWed, 16 Apr 2008 20:18:14 GMTsatyapal