SQL selective qty difference

From: Anil G <anil.gothal_at_gmail.com>
Date: 5 Sep 2006 15:01:33 -0700
Message-ID: <1157493693.095029.159090@e3g2000cwe.googlegroups.com>

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 Received on Tue Sep 05 2006 - 17:01:33 CDT