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!

Subtract two sql statements

Ann 81Oct 28 2013 — edited Oct 28 2013

I have 2 queries,

query1 --SELECT A1,B1,C1 FROM TAB1

A1    B1   C1

10     5   6

query-2 SELECT A2,B2,C2 FROM TAB2

A2  B2  C2

5   7    4

How to find

A1-A2 ,B1-B2,C1-C2

EXPECTED

A1-A2     B1-B2    C1-C2

5                   -2       2

Please help
This post has been answered by Frank Kulash on Oct 28 2013
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 25 2013
Added on Oct 28 2013
2 comments
820 views