Question 115111 in PostgreSQL Question posted in
The official documentation can be found here.

PostgreSQL find the sum of two queries from different tables

I have two queries that returns the total number of issuances and redemptions from two different tables.

This one returns issuances, around 18k

select
  count(*)
from
  issuances_extended
WHERE
  status = 'completed'

This one returns redemptions, around 7k

select
  count(*)
from
  redemptions_extended
WHERE
  status = 'completed'

I need the sum of them, I came up with this but this only returns 2, counting it wrong

with active_user as (
  select
    count(*) as issuance_count
  from
    issuances_extended
  where
    status = 'completed'
  UNION ALL
  select
    count(*) as redemption_count
  from
    redemptions_extended
  where
    status = 'completed'
  )
  select
    count(*)
  from
    active_user

What should I do?

Tags:

2

Answers


  1. 0

    use sum()- instead of count() in outer query

    with active_user as (
  select
    count(*) as issuance_count
  from
    issuances_extended
  where
    status = 'completed'
  UNION ALL
  select
    count(*) as redemption_count
  from
    redemptions_extended
  where
    status = 'completed'
  )
  select
   sum(issuance_count)
  from
    active_user
    Login or Signup to reply.
  2. 0 
    select 
  (select count(*) from issuances_extended WHERE status = 'completed')
+ (select count(*) from redemptions_extended WHERE status = 'completed')
  AS result
    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search