Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

reporting query help

jdiAug 17 2010 — edited Aug 17 2010
Hi

Could someone guide me how to do this? 
Table Data

NID  COMPANY PID

ALM   A4U     15
ALM   B4U     18
ALM   C4U     22
ALM   D4U      9
BLM   C4U     10
BLM   B4U      5
Desired Output
NID    A4U   B4U C4U D4U  Diff (Max-Min)
ALM   15       18    22   9     13
BLM              5     10            5
Thanks

Edited by: jdi on Aug 17, 2010 1:51 PM

Edited by: jdi on Aug 17, 2010 1:53 PM

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Sep 14 2010
Added on Aug 17 2010
4 comments
827 views