Pivoting rows to Columns

Visit Teradata.com

Home

Guidelines

Member List

Welcome Guest ( Login | Register )

This online forum is for user-to-user discussions of Teradata products, and is not an official customer support channel for Teradata. If you require direct assistance, please contact Teradata support.

Pivoting rows to Columns

Rate Topic

Display Mode

Topic Options

Author

Message

samit_9999

Posted 8/30/2006 4:46:53 PM

Forum Member

Group: Forum Members
Last Login: 5/19/2008 11:39:33 AM
Posts: 29, Visits: 19

Hi,

I have a table with data in the following format

Dept Emp
10 12
10 11
10 13
10 15
10 14
20 50
20 51
20 55
20 40
20 44
20 46
20 33

I want to sort the data , pivot these results based on Dept# and get the first four values in 4 different columns as follows
Dept Emp1 Emp2 Emp3 Emp4
10 11 12 13 14
20 33 40 44 46

Please let me know if pivoting can be done in Teradata SQL and how do i acheive the above results.

Thanks,
Sam

Sam

Post #5030

dnoeth

Posted 8/31/2006 12:31:22 PM

Supreme Being

Group: Forum Members
Last Login: 2 days ago @ 3:41:05 AM
Posts: 522, Visits: 264

Hi Sam,

http://www.teradata.com/teradataForum/shwmessage.aspx?forumid=10&messageid=1285

Dieter

Post #5038

« Prev Topic | Next Topic »

Reading This Topic

Active Users: 0 ( 0 guests, 0 members, 0 anonymous members )

No members currently viewing this topic.

All times are GMT -5:00, Time now is 9:22am