View previous topic :: View next topic
|
Author |
Message |
srvmani Warnings : 1 New User
Joined: 30 Dec 2003 Posts: 19
|
|
|
|
Hi
I have the following query
select sum(salary), basic, tax from the table1
union
selct sum(salary), basic,tax from the table2
the result would be like below
sum(sal) basic tax
--------------------------
7500 5000 10.5
8500 2000 11.5
But I want out put be like below
sum(sal) basic tax
------------------------
16000 70000 22.0
I have tried in several ways. Could you please let me know how to write a query to get the above output.
Thanks
Subba |
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
can't test it, too lazy to bring up db2,
but
Code: |
select sum(t.salary) as SALARY
, sum(t.basic) as BASIC
, sum(t.tax) as TAX
from (
select sum(salary)
, sum(basic)
, sum(tax)
from table1
union
select sum(salary)
, sum(basic)
, sum(tax)
from table2
) as t
|
|
|
Back to top |
|
|
rocky_balboa
New User
Joined: 24 Mar 2010 Posts: 61 Location: Cape of Good Hope
|
|
|
|
dbzTHEdinosauer
I am lazier than you....I was going to post about the inline view so that he could try it himself....but you have posted the entire query ...
You have made him much more lazy... |
|
Back to top |
|
|
ashimer
Active Member
Joined: 13 Feb 2004 Posts: 551 Location: Bangalore
|
|
|
|
Probably it should be an UNION ALL so that duplicates are retained. |
|
Back to top |
|
|
|