CODEWITHSUNDEEP
mysql
Ignacio López García
Ignacio López García

Reputation: 21

Compute sum of counts using union

SELECT COUNT(id) AS Cuenta FROM prerating_calculos 
WHERE usuario NOT LIKE 'TEST' AND usuario NOT LIKE 'ADMIN' 
UNION SELECT COUNT(id) AS Cuenta FROM prerating_calculos_apx 
WHERE usuario NOT LIKE 'TEST' AND usuario NOT LIKE 'ADMIN'

This is what it shows me

----------   
| Cuenta |
----------
|   1    |
----------
|   75   |
----------

This is what I want you to show me

----------   
| Cuenta |
----------
|   76   |
----------

Upvotes: 0

Views: 32

Answers (1)

PaulS
PaulS

Reputation: 940

What you need to do is to implement a subselect, selecting the sum from your initial query.

SELECT SUM(Cuenta) FROM
    (SELECT COUNT(id) AS Cuenta FROM prerating_calculos 
    WHERE usuario NOT LIKE 'TEST' AND usuario NOT LIKE 'ADMIN' 
    UNION SELECT COUNT(id) AS Cuenta FROM prerating_calculos_apx 
    WHERE usuario NOT LIKE 'TEST' AND usuario NOT LIKE 'ADMIN') AS T1

Upvotes: 3

Related Questions