Hi,

I have following data structure into table

Name Type Qty
-------- ------- --------
N1 D 3 --------|
N1 F 2 | ----> Difference (D - I) DIDFF
------------|
N1 I 4 --------|
|----> (S - DIDIFF) as SDIFF
N1 S 10
----------------------------------------------------------------|
N2 D 2
....
....


Any clues about performing above type operations using SQL query rather
than writing PL/SQL???


Thanks in advance,

Anil G