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!

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
852 views