Adding the total of two SUM functions

Question

How can I do to sum the result of this queries using postgresql?:

SELECT SUM(value) FROM credit_balance

SELECT SUM(value) FROM debit_balance

I have tried this but it doesn't work:

SELECT SUM(SELECT SUM(value) FROM credit_balance UNION ALL SELECT SUM(value) FROM debit_balance)

SQLChao · Accepted Answer · 2014-09-25 18:54:08Z

3

SELECT
  (SELECT SUM(value) FROM credit_balance) + (SELECT SUM(value) FROM debit_balance)

answered Sep 25, 2014 at 18:54

SQLChao

7,8851 gold badge19 silver badges33 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

The Code · Accepted Answer · 2014-09-25 19:13:30Z

0

You are missing the field name after sum. you can write your query using union all as following:

select sum(val_sum) from (SELECT SUM(value) as val_sum FROM credit_balance UNION ALL SELECT SUM(value) as val_sum FROM debit_balance) as united_table;

OR

select sum(value) from (SELECT value FROM credit_balance UNION ALL SELECT value FROM debit_balance) as united_table.

answered Sep 25, 2014 at 19:13

The Code

1,3191 gold badge7 silver badges11 bronze badges

Collectives™ on Stack Overflow

Adding the total of two SUM functions

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related