How to add results of two select commands in same query

Question

I currently have two select commands as per below  What I would like to do is to add the results together in the SQL query rather than the variables in code   select sum hours  from resource  select sum hours  from projects-time    Is it possible to have both in the same SQL and output a sum of both results

User · Answer

Something simple like this can be done using subqueries in the select clause:

select ((select sum(hours) from resource) +
        (select sum(hours) from projects-time)
       ) as totalHours

For such a simple query as this, such a subselect is reasonable.

In some databases, you might have to add from dual for the query to compile.

If you want to output each individually:

select (select sum(hours) from resource) as ResourceHours,
       (select sum(hours) from projects-time) as ProjectHours

If you want both and the sum, a subquery is handy:

select ResourceHours, ProjectHours, (ResourceHours+ProjecctHours) as TotalHours
from (select (select sum(hours) from resource) as ResourceHours,
             (select sum(hours) from projects-time) as ProjectHours
     ) t

User · Answer

Repeat for Multiple aggregations like   SELECT sum AMOUNT  AS TOTAL AMOUNT FROM        SELECT AMOUNT FROM table 1     UNION ALL      SELECT AMOUNT FROM table 2      UNION ALL      SELECT ASSURED SUM FROM table 3

User · Answer

UNION ALL once  aggregate once   SELECT sum hours  AS total hours FROM        SELECT hours FROM resource    UNION ALL    SELECT hours FROM  projects-time  -- illegal name without quotes in most RDBMS      x

User · Answer

If you want to make multiple operation use   select  sel1 s1 sel2 s2    select sum hours  s1 from resource  sel1 join   select sum hours  s2 from projects-time sel2 on sel1 s1 sel2 s2

User · Answer

Yes  It is possible  D  SELECT  SUM totalHours  totalHours FROM                        select sum hours  totalHours from resource             UNION ALL             select sum hours  totalHours from projects-time           s   As a sidenote  the tablename projects-time must be delimited to avoid syntax error  Delimiter symbols vary on RDBMS you are using

[sql] How to add results of two select commands in same query

Examples related to sql

Examples related to sqlite

Examples related to select