mrong
asked on
Oracle Pivot
Greeting,
I have a select stmt with the following output.
empID FirstName LastName Work_type Rate
00001 John Smith RE 20
00001 John Smith OT 40
00002 Bob Jackson RE 25
I'd like to make the change to get the following output
empID FirstName LastName RE_Rate OT_Rate
00001 John Smith 20 40
00002 Bob Jackson 25
Thanks in advance.
I have a select stmt with the following output.
empID FirstName LastName Work_type Rate
00001 John Smith RE 20
00001 John Smith OT 40
00002 Bob Jackson RE 25
I'd like to make the change to get the following output
empID FirstName LastName RE_Rate OT_Rate
00001 John Smith 20 40
00002 Bob Jackson 25
Thanks in advance.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER